Visual Basic Jobs

Every event that I have, I take an average of 30 event orders, pull them apart and chronologically construct a production plan for moving in and setting up an event and moving it out at the end of the event. I would like to drop a text-based Event Order PDF into a dedicated local folder. The moment that file lands, I need an agent to wake up, read the document, and do three things automatically: 1. Pull out the essentials—event dates and times, the title of each order, and the Event Order Number. 2. Duplicate each order so it appears "chronologically" twice in the output: once for the install date and once again for the strike / move-out date. 3. Feed all rows into a single, combined Excel sheet that becomes my Production Plan (this is already formatted and I can send...

I’d like a detailed, realistic pencil rendering of a woman’s upper body, semi-nude, to be created from a specific pose I already have in mind. As soon as we open a dialogue I will share the reference photo so you can capture the exact posture, lighting, and expression I’m after. The piece will ultimately hang in her place in Medellín, so it needs to feel refined enough for display: clean graphite tones, subtle shading transitions, and a confident line that preserves anatomical accuracy without overworking the paper. Traditional graphite on quality drawing stock is preferred, though I’m open to your usual materials if they achieve a similarly crisp result. Deliverables • High-resolution scan (300 dpi or higher) suitable for archival printing - NO &bul...

Help provide a analysis on the commercial side

I have a raw sales dataset sitting in Excel and need it reshaped into clear, insightful pivot tables that let me track sales trends at a glance. The goal is to transform the sheet so I can slice results by time period, product line, region, or any other meaningful field, then spot upward or downward movements without manual filtering every week. What I’ll hand over: • A clean Excel workbook containing all transactional sales records. What I expect back: • One or more well-structured pivot tables designed specifically for trend tracking. • Any supporting formulas or helper columns you create, kept within the same file and clearly labeled. • Brief notes (a few lines inside the sheet or a separate tab) explaining how to refresh or expand the analysis when new s...

I need a single-file Excel dashboard that lets me monitor revenue and expenses alongside overall profit-and-loss performance, then projects those figures forward with clear, reliable forecasts. The workbook should pull raw data from one or more clean tables, refresh at the click of a button, and display the key numbers through interactive charts, slicers or drop-downs so I can drill down by month, quarter and year. A dedicated section for predictive analytics—using built-in Forecast Sheet, Power Query/Power Pivot, or another proven method you prefer—should show at least a 12-month outlook with confidence intervals highlighted. Deliverables • Finished .xlsx file, no external add-ins required • Documentation tab outlining data layout, formulas or DAX measures,...

I need an .xlsm workbook whose VBA macro fetches product data from both and lowes.com. When I type a valid item or model number into a row, the code should automatically pull back: product name, full description, regular price, sale price (if available), brand, product type/category, and the main image (inserted into the sheet or stored in an Image column). I work comfortably with VBA, so a concise, well-commented routine is all I need—no step-by-step user guide. The workbook must stay self-contained, relying only on standard references such as Microsoft XML, HTML, or WinHTTP libraries; please avoid external add-ins or Python bridges. Deliverables: • Finished macro-enabled Excel file (.xlsm) ready to test with my own SKU list • Clearly commented VBA code so I can...

I have an Excel workbook that already runs several VBA macros. Right now I need an extra routine added that, at the click of a button, builds an automated report containing clear graphs and charts drawn from the data that the existing code produces. Timing is tight—I will be online for the next two to three hours and would like to screenshare while you code so we can iterate quickly. Scope of the mini-upgrade • Insert a new sub or function into the current module stack that gathers the daily results, drops them onto a neatly formatted “Report” sheet, and then creates the required charts (line and bar are fine; feel free to suggest better visuals if you see fit). • Ensure the macro runs smoothly on both Office 365 and Excel 2016, without touching the pe...

I’m looking for an experienced Microsoft Copilot / Power Automate to help me build an end-to-end productivity automation system. The objective is to automate customer escalations, MIS reporting, fraud detection, growth analysis, email workflows, and PowerPoint creation using the Microsoft ecosystem + Copilot. ⚠️ Important: This project is time-critical and needs to be completed within this week, as all required data, formats, and inputs are already available. ⸻ Timeline (Critical) • Start: Immediately • Completion: Within 5 days ⸻ Scope of Work 1. Automated Customer Escalation Replies • Auto-reply to customer escalation emails with personalized responses • Replies based on: • Standard predefined issue types • Error screenshots attached by...

I need a Power BI or custom app to create a workflow dashboard based on my existing process map. I am not sure whether an App or Power Bi is better? Essentially we want to track the duties of the 4 dutyholders under the building safety act. Client, Designer, Principal designer and the designer. The client will just see the summary dashboard with all the headlines... I have added some workflows to the files section with my initial thoughts. We will need some work to also build the trackers in the background. Most of mine is in either excell or word declarations etc.. Requirements: - Use Excel files as data sources. - Include interactive charts and graphs. - Generate summary reports. - Provide real-time data updates. Ideal skills and experience: - Proficiency in Power BI or app developmen...

I’m looking to streamline the way I track stock levels by turning a series of existing internal spreadsheets into a single, button-driven inventory report. Right now, the data sits in multiple Excel files that are updated daily by different team members; what I need is a routine—whether VBA macros, Power Query, or another native Excel solution—that pulls those sheets together, cleans the figures, and produces a polished inventory snapshot ready for management every morning. The core workflow I have in mind is simple: once the operator clicks “Generate,” your automation should gather the latest numbers from our internal workbooks, reconcile duplicates, highlight discrepancies, and output a formatted report (PDF and XLSX) showing on-hand counts, reorder points,...

I have a mixed set of text and numeric records that need to be moved into a master Excel workbook, carefully cleaned, and laid out so everything is easy to read and filter. Fewer than 1,000 numeric rows are involved, but each row carries accompanying text fields, so absolute precision matters. Key tasks include: • Typing the data exactly as supplied, checking every character for accuracy. • Applying my existing color-coding scheme to highlight status and priority. • Tidying column widths, headings, and basic formulas so the sheet is ready for quick sorting and filtering. I will supply the source files and the color legend; you return a finished .xlsx file—no broken formulas, no stray spaces, and every entry verified. If you spot inconsistencies, note them i...

I have a collection of customer information that must be organised accurately in Excel. Your job is to take the raw details I provide—names, contact numbers, email addresses, and any extra fields I specify—and enter them into a clean, well-structured spreadsheet. The spreadsheet has to follow the column layout I give you, preserve exact spelling, and avoid duplicate records. I will share the source files in batches; each batch should be completed and sent back for a quick review before you move on to the next. I value precision over speed, but I still need a reasonable turnaround so my own workflow isn’t delayed. If you are comfortable handling typical Excel functions—data validation, basic formatting, and simple filtering—that will help keep the file consis...

My recruitment pipeline already lives in Excel; what’s missing is a hands-free way to turn that raw sheet into insight I can act on every morning. I need an Excel-based solution—whether it relies on formulas, VBA macros, Power Query, or a light Power Pivot model—that will automatically crunch the data I enter during the day and, by the next day, give me: • Daily Candidate Performance reports • Daily Recruitment Progress summaries • Daily Source-of-Hire breakdowns The reports should refresh with a single click (or on workbook open), capture any new rows I add, and present the metrics in a clean, printable format—charts or pivot tables are welcome as long as they stay linked to the underlying data. Clear documentation inside the workbook or a sh...

I need a set of Excel sheets purpose-built for handling quotations. I’ll be typing in quotation details rather than running extensive analyses, so the layout has to make entering text, line items and basic figures quick and error-free. Here’s what matters to me: • A clean, intuitive structure where I can add or remove rows without breaking any formulas. • Logical sections for item description, quantity, price and total so the sheet doubles as a professional-looking quote I can send to clients. • Basic formulas that automatically extend when new lines are added, plus a final summary field that clearly shows the grand total. • Print- and PDF-friendly formatting. I’ll share a small sample of the data I’ll be entering and I’m happy to ...

I am putting together a single-page Excel workbook that keeps every investigation I’m handling neatly organised and easy to review at a glance. The sheet must start with a status drop-down that lets me sort the jobs from top to bottom in this exact order: “initial active”, “interpose”, “offender processed”, “at court”, and “completed”. Alongside that status column I need the following fields laid out logically across the row: Suspect details, Investigation notes, Due dates, To do task, and Property. Of those, Due dates and To do task are the two I rely on most, so they should stand out visually and be simple to filter. The To do task column itself needs its own drop-down list containing: Collect evidence, CCTV collect, St...

I need a well-structured MIS report in Excel that focuses solely on employee attendance. I will supply raw time-in/time-out sheets; what I’m looking for is a clean workbook that transforms that data into meaningful insights—daily, weekly, and monthly views, absence summaries, and any red-flag trends you feel would help management act quickly. Please rely on solid Excel techniques—pivot tables, lookup formulas, conditional formatting, perhaps a touch of Power Query if it speeds refresh. The final file should be plug-and-play: I drop new data into an “Input” sheet and every metric updates automatically, no extra tweaking. Deliverables • One unlocked Excel workbook containing the MIS attendance report • Brief notes inside the file (or a single-pag...

Título del proyecto Automatización RPA en DATAX: Facturación/causación desde Excel con arquitectura escalable (futuro OCR + “memoria” por proveedor) Contexto Somos una firma contable en Colombia. Usamos DATAX para registrar/causar y/o facturar. Queremos eliminar digitación manual con un bot RPA. Empezaremos con Excel → RPA → DATAX, pero el diseño debe quedar preparado para escalar a: carpeta con facturas (PDF/XML) → extracción de datos → reglas contables por proveedor → ejecución en DATAX. Objetivo Fase 1 (MVP en 3–5 semanas) Implementar un bot RPA que, a partir de un Excel maestro, cree/registre (según aplique) facturas/causaciones en DATAX y genere evidencia de ejecución. A...

I want to make pdf hiking guides from data in a spreadsheet. There are 280 peaks, each with 1-5 hiking routes each. I want one pdf hiking guide for each peak that will contain information about the peak and about each of the routes including text descriptions (including the distance, difficulty, trailhead location, notes etc. points of interest, elevation profile, expected time), driving and hiking directions for each route, links to outside sites and links to documents on our web site that must stay active in the final document. Adding elevation profiles to the docs would be a plus (from existing images; a sample is in the files). The goal is to produce a set of documents, one per each of 280 peak and also have a repeatable process for future use. Sample results are in the files. W...

I already have a working estimating spreadsheet program with extensive data base. I now need to add further columns to improve the estimating spreadsheet. Here is what I’m looking for: • Add to the current spreadsheet with additional information i have. • Display the information from a data base. • Make sure the new calculations pick up the same input data fields • Provide clear, concise documentation of every new function and a short change-log so I can track what was modified. • Include a small sample project or test file showing the results of the new time calculations against known benchmarks; this will be the acceptance criterion. The existing program is stable and I have full source control access; you will receive a Git branch to work in. ...

I need an Excel sheet tidy-up to track factory production rates efficiently. Requirements: - Organize data into simple tables - Ensure sheet is user-friendly and easily updateable Ideal Skills: - Proficiency in Excel - Experience with data organization and automation - Attention to detail Please provide samples of previous work.

I have a set of voter-list PDFs released by the election commission. The layout across all files is identical, so positional parsing is reliable. Right now I simply need the current batch converted, but long-term I want a reusable Python utility that pulls the following six columns straight into Excel: • Name • FathersName • Age • Gender • VoterID • SerialNumber . Section Name . Polling Station Name .etc. Scope of work 1. Run the first extraction and hand me the .xlsx file so I can verify accuracy. 2. Package the underlying code (Python 3.x) with clear instructions and any so I can repeat the conversion on future lists without further help. Technical notes – Consistent layout means you can lean on libraries like pdfplumber, camelo...

I have a multi-sheet Recruitment Tracker that needs to be distilled into a single, interactive dashboard in Excel. During a live screen-sharing session I want to walk through the raw data with you, connect the sheets properly, and shape a view that updates automatically. The finished dashboard should let me monitor five specific hiring metrics at a glance: Time to hire, Source of applicants, Candidates by stage, Open roles, and Hires by department and more. Bar charts will handle comparisons, pie charts will highlight shares, and line graphs will show trends over time. I’m happy to lean on PivotTables, slicers, or Power Query—whatever keeps the file lightweight and refreshable. By the end of our session I expect: • one tidy, well-labeled workbook that pulls from my exist...

Excel Expert Needed – Advanced Quotation Calculator Automation We are looking for a highly skilled Microsoft Excel expert to help us finalize and optimize a complex quotation calculator. We are building an Excel-based pricing and quotation system for an extensive product range with multiple categories, variations, and optional add-ons. The main challenge is creating a fully automated structure where all selections dynamically update a central quotation summary. The workbook requires advanced formulas and smart automation so that: - Product categories, variations, and add-ons are linked logically - All selections are reflected correctly in the summary page - Prices, options, and totals update automatically - A change in one place updates multiple dependent fields - The structure is...

I have roughly 250 scanned images that mix Latin-based text with Amharic script i two columns per page. I need the content from each image turned into a clean, fully editable Microsoft Word document (.docx), keeping original paragraph breaks, headings, and any basic formatting that appears in the source. You may use whichever OCR engine or workflow you trust—Tesseract, ABBYY FineReader, Google Vision, or a custom pipeline—as long as it handles Amharic reliably and leaves me with error-free text. Manual review and correction after the automated pass are essential; I’m expecting a result that reads naturally and is ready for immediate editing, not a raw OCR dump. Deliverables • One .docx file per image, named to match the source file or one single doc file • ...

import pandas as pd EXCEL_FILE = "" # ----------------------------- # Create Excel Template # ----------------------------- def create_excel_template(): data = { "Service_ID": [], "Sub_Function": [], "DID": [], "Description": [], "Data": [] } df = (data) df.to_excel(EXCEL_FILE, index=False) print(f"Excel template created: {EXCEL_FILE}") # ----------------------------- # Read and Parse Excel # ----------------------------- def parse_excel(): df = pd.read_excel(EXCEL_FILE) # Remove completely empty rows df = (how="all") # Replace NaN with None df = ((df), None) structured_data = [] for _, row in (): service_d...

I need my monthly electricity bills transferred into a clean, well-structured Excel workbook. For every statement I receive, I want one row that captures columns of data: the billing date, usage in kWh, total cost, current read, previous read current usage and any remaining credits that appear on the bill. Edit: I have approx 100 previous bills I would like added to the spreadsheet. Please set up the file so I can keep adding future bills myself—simple data-validated entry boxes or a protected template sheet would be appreciated. A running year-to-date summary that auto-totals usage and spend would be a useful bonus, though not mandatory. Deliverables • Excel file (.xlsx) with the template sheet and at least one sample entry filled in • Clear instructions (a short note...

I have a multi-sheet Excel project that starts with a plain text file and ends with dynamic dashboards. I need you to take the raw content, import it, and turn it into a fully structured, well-formatted workbook that is ready for executive review. Here is the flow I follow every month and want automated or documented so anyone can repeat it: • Open the starter workbook, rename it to the current reporting period, and save it to the network location I will supply. • Import the supplied text file then convert it into a properly sized Excel table. • Apply my preset formatting rules—this includes conditional formatting for key metrics, custom number formats for currency and percentages, plus the cell styles and theme colors that match our brand guidelines. • Du...

I have four spreadsheets in total—three inventory feeds from separate dropshippers plus my own master product list. Your task is to merge these files, align every item by its SKU, part number, or manufacturer part number (whichever matches first), and refresh the quantity on my master list. Here’s exactly what I need done: • Consolidate all four files in Excel. • Use the SKU/part-number fields as the sole matching key. • Whenever the same item appears in more than one feed, set the quantity to the highest figure found. • Keep every column that exists in any of the source sheets so nothing is lost; I want a single, fully populated file back. • Flag anything that doesn’t find a match so I can review quickly. Please deliver the finished w...

I need help to tabulate data from 1-5 Excel spreadsheets. The data is to be used for customer productivity and incentive calculation. Key tasks include: - Tabulating sales figures - Tabulating performance metrics Ideal skills and experience: - Proficiency in Excel - Experience with data tabulation and automation - Attention to detail

I need to turn an Excel sheet that holds status and transaction data into a single XML text file so my website can import it without complaints. The site expects very specific, custom tags, and I’ll share a sample file plus the exact tag map and hierarchy you must follow. Your task is to take the spreadsheet I provide and give me a repeatable way—VBA, Macro based, Power Query, or any approach you prefer—to generate a UTF-8 XML file that matches the structure perfectly. The converter must: • read every row of the sheet, • map columns to the custom tags I supply, • preserve dates, numbers, and special characters exactly as entered, • output a clean XML file ready for immediate website import. Deliverables I expect: 1. A working script, macro, or...

I need an Excel automation solution to streamline the summarization and reporting of demand data. Requirements: - Automate data summarization and reporting tasks - Use of tables for summary reports Ideal Skills and Experience: - Proficiency in Excel, especially in automation tools like VBA - Experience in data analysis and reporting - Ability to create structured and well-organized tables Looking for a freelancer who can deliver efficient and reliable automation.

I run an entertainment-focused YouTube channel and want to level up my thumbnails while I’m still learning the craft myself. I’d like you to design a series of clean, eye-catching thumbnails and walk me through the decisions you make so I can steadily improve. What matters most to me: bold, easy-to-read text, high-contrast colours that pop in the feed, and images that feel instantly relevant to each video’s topic. Along the way, please give clear, constructive pointers on overall layout, colour choices, and any other design tips that will make my future work stronger. Typical tools you might use—Photoshop, Illustrator, Canva, or Figma—are all fine as long as the final files are layered and editable. Standard YouTube sizing (1280 × 720, <2 MB) applie...

I have a raw CSV that needs to become a streamlined analysis workbook. The goal is to bring the data into Excel, shape it into a named table, and layer on the tools I use most—Advanced Filters, Conditional Formatting, and PivotTables—so I can slice, summarise, and visualise the information quickly. Here’s the flow I want to see inside the final file: • Import the CSV and convert it to a properly sized, named table. • Build an Advanced Filter (criteria on a separate sheet) so I can isolate records by multiple fields. • Apply a multi-level sort to any filtered view to keep results in logical order. • Add conditional formatting that highlights key exceptions or trends; rules should be easy for me to adjust later. • Demonstrate converting th...

I need a single Microsoft Excel workbook that already contains a full, properly scaled map of the United States—every state, every county. Inside that file I want to be able to: • Fill or change the color of any county so I can instantly show where each customer is located as we add new business. • Add, remove, or recolor states automatically when several counties inside them are selected. • Place one clearly visible annotation that identifies our main office; I should be able to move or rename that label myself. My source data will arrive as standard .xls or .xlsx spreadsheets, so the map has to accept county names or FIPS codes from those sheets and update the colors with as little manual work as possible (a macro, Power Query, or any Excel-native method you ...

I need a spreadsheet tool to manage quarterly price and inventory changes from my supplier. Requirements: - Cross-reference supplier's Excel catalog with my current Excel inventory and price sheet. - Generate pop-up alerts within the spreadsheet for any changes that affect my prices. Ideal Skills: - Proficiency in Excel, especially with formulas and alerts. - Experience in inventory management. - Attention to detail and accuracy.

I have a batch of source files that need to be keyed into my existing template exactly as they appear. The work is strictly manual—no macros, OCR, or automated scraping—because accuracy down to every character matters. The information you will be handling is a mix of letters and numbers (product codes, IDs, reference strings, etc.). I’ll provide the Excel template with locked headers, drop-down validation where needed, and a short set of field notes so you always know what belongs in each column. Your task is simply to open each source file, copy the alphanumeric value, and paste it into the correct cell without altering the formatting. Deliverable • The completed template populated with all entries, saved in the same file structure I provide. • A br...

I have a collection of Notepad files that contain mixed data—snippets of text, numbers, and the occasional alphanumeric code. Your task is to transfer every line into a clean Excel workbook, observing a few house-style rules that I will cover during a brief onboarding call. The spreadsheet will need custom cell formatting rather than a simple copy-paste: dates must read correctly, numerical strings should remain as numbers (not text), and certain text segments need a light wrap so nothing is hidden from view. I’ll supply clear written guidelines with screenshots, but no pre-built template; you’ll build the sheet from scratch based on those instructions. Accuracy is everything here. I’ll run random spot-checks once the first set is complete, and any inconsisten...

I have several spreadsheets of raw sales data that need to be merged into a single, reliable source. Your first task is to remove duplicates, fix mis-aligned headers, standardise date and currency formats, and generally make sure every column is analysis-ready. Once the data is spotless, I want clear, interactive visuals—think slicers, pivot-based charts, or a compact dashboard—built either in Excel or Power BI (I’m open to whichever tool you work fastest and most creatively in). When you’re done, include a concise handoff note that walks through the key formulas, any Power Query steps, and how I can refresh the visuals with new data. Please highlight your experience doing similar consolidation and dashboard work; that’s the main thing I’ll use to ...

I have a collection of Excel spreadsheets that need to be brought together, checked for accuracy, and turned into clear, compelling visuals. Your job starts with careful data entry: copy or import every row exactly as it appears, resolve obvious typos, and flag anything that doesn’t look right. Once the data is clean we move straight into visualisation. Simple, readable charts or an interactive dashboard—whichever best highlights the key insights—is what I’m after. You may work entirely in Excel (pivot charts, slicers, conditional formatting) or move the finished dataset into Power BI, Tableau, or Google Sheets if that delivers a clearer story; I’m flexible as long as the final result stays easy for me to update later. Deliverables • One consolidated,...

In one column I have repeating state codes—WA, WA, SA, SA, ACT, ACT, WA, WA—and I simply need an automatic way to display each code once. The duplicates should disappear (no highlighting, no counting) and the tidy, de-duplicated list must appear in a new column right beside the source data. A neighbouring column already holds the running total of uniques (currently 3 for WA, SA, ACT), so your solution only has to focus on extracting the distinct values themselves. Please provide a single formula (or a compact, copy-ready combination of formulas) that I can drop into the worksheet without restructuring anything else. It should work regardless of future changes in the original column’s length. If different Excel versions require slightly different syntax, include each v...

Silakan Daftar atau Login tuntuk melihat rincian.

I’m looking for a talented graphic designer to craft a clean, minimalist logo that will become the core visual mark for my brand. I haven’t locked myself into any color palette yet, so I’d like you to propose tones that amplify the minimalist feel while still giving the brand a memorable presence. Here’s what I need from you: • Three distinct minimalist concepts based on a short creative brief I’ll share once we start. • One selected concept taken through two rounds of refinement. • Final deliverables in vector (AI/SVG), high-resolution PNG and JPG, plus a monochrome version and a concise color-palette guide so I can keep future collateral consistent. If your portfolio shows strong typographic skills, clever negative-space usage or s...

I’m looking for a seasoned Zendesk specialist who can sit with me (remote screen-share is fine) for a few focused hours and walk me through three areas: • Building Explore reports with practical filters. My top priority is learning how to slice Ticket resolution times and Agent performance metrics—plus a custom “time spent per customer” field—by date range and agent name. I want to leave the session with at least one working dashboard and the confidence to duplicate the process on my own. This is not just a report with one filter, but how filters can work together. • Making the most of Zendesk’s AI chat. I already have the feature enabled; I need guidance on training phrases, intent routing and best-practice configuration so the bot hands of...

I’m looking for one versatile professional who is equally comfortable in Excel and Corel Draw. Excel task I have a dataset that needs clear, insightful analysis. You’ll clean the data, explore relationships, build pivot tables, apply basic statistical methods, and surface key findings in a well-structured workbook. Corel Draw task I also need a fresh, text-only logo created directly in Corel Draw. The goal is crisp, legible typography that reflects a modern, professional feel. No icons or color palettes required—just strong type treatment. Please provide the editable .cdr file plus a high-resolution transparent PNG and an SVG export. Deliverables • .xlsx file containing the cleaned data, pivot tables, formulas, and written insights • Corel Draw .cdr o...

I have a set of raw financial records that must be entered into Excel and arranged strictly by date. I will forward the source files (PDF statements and the occasional CSV download); every transaction line needs to be keyed in, totals verified, and the final sheet sorted chronologically from the oldest entry to the most recent. I’ll also provide a concise style guide covering number formats, header rows, cell styles, and a colour code that highlights income versus expense. Please follow those custom formatting instructions so the workbook is client-ready the moment it lands back in my inbox. Because these files contain confidential account figures, I need someone who treats data security as non-negotiable and is willing to delete local copies once the project closes. A quick turnar...

I have several spreadsheets that now feel unwieldy and inconsistent. I need someone who can step in, quickly understand the structure, and turn them into clean, reliable workbooks. Here’s what I specifically need: • Data entry of new records without introducing errors • Applying the right filters so the information I need surfaces instantly • Building or correcting formulas to automate totals, look-ups, and other basic calculations You’re welcome to suggest smarter ways to structure the sheets if it will speed up future updates. If things go smoothly, I may also pass along some light photo edits and ID-card layout tweaks later, but the first milestone is all about getting these Excel files running efficiently. The deliverable is a polished workbook...

Looking for an experienced freelancer to build a formula-based Excel (.xlsx) tool that generates EDIG@S EDIFACT NOMINT messages for gas nominations. Requirements • Generate NOMINT messages (single & multi-point) • Correct EDIG@S segments: UNH, BGM, DTM, NAD, SEQ, LOC, QTY, RFF (opt), UNT • Automatic and correct UNT segment count • Excel formulas only for all EDIG@S logic (no VBA for message generation) • Optional VBA only to export the generated text to a .edi file • Clean input/output separation, ops-friendly Nice to have • Read-only viewing of CONTRL / APERAK • Simple ALLOC generation (daily only) Deliverables • Excel file + brief instructions • Sample NOMINT output MUST HAVE SKILLS • Hands-on EDIFACT / EDIG@S expe...

Build Excel Dashboards & KPI Reporting Tools We are looking for an Excel dashboard specialist to build business and performance dashboards using Excel. These dashboards will be used by managers and decision-makers for reporting and analysis. What You Will Develop You will build Excel dashboards and analytics tools, including: KPI and performance dashboards Sales and marketing dashboards Funnel and conversion tracking dashboards Summary and reporting dashboards Each dashboard will be an interactive Excel file with charts and summaries.

I need every bit of information currently stored in my Tally company—masters, vouchers, inventory, bank transactions, statutory ledgers, the lot—pulled out once and delivered in a clean, tabular Excel workbook. The extraction must be fully automated (TDL, ODBC, or any method you’re comfortable with) so I can rerun it later, but this engagement covers a single execution and hand-over. Deliverables • An Excel file where each dataset appears as a properly labeled table, with field names matching Tally, dates and numbers intact, ready for analysis or import elsewhere. We will provide Tally data file. Let me know which approach you prefer (TDL, ODBC, etc.) and how quickly you can turn the finished workbook around. Please also advise your working days and hours.

I need an Excel dashboard to visualize operational data, specifically focusing on procurement across different companies. The dashboard will be used for data visualization purposes. The data set is already created, along with some ref pivot tables for IDEA. just need Help with the visualization of the content along with a few addons based on requirements. The data set talks through the Procurement plans from different global regions for the next 3 Financial years with some key metrics needed to be captured for easy user/team viewing of the plan and progress Requirements: - Ability to create visually aesthetic, interactive and user-friendly Excel dashboards - Expertise in data visualization techniques - Experience with operational data analysis - Ideal Skills and Experience: - Strong a...