Visual Basic Jobs

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...

I have an Excel sheet that already contains options prices, futures prices and strike prices laid out in raw tables. I need a second workbook (or a re-structured copy of the same one) that automatically recognises the at-the-money (ATM) strike, computes the corresponding straddle value, and shows the ratio of that straddle to the current futures price. The file should refresh these three metrics instantly whenever I paste new daily data. The layout I have in mind is simple: source data on one tab, clean summary on another. Formulas are fine; a small VBA routine or Power Query step is welcome if it keeps the workbook fast and eliminates manual intervention. Deliverables • A working .xlsx file with clearly labelled input and output areas • Built-in calculations for:  1...

I’m putting together a sleek, gender-neutral tracker that lives both in Excel and Google Sheets. The file will let everyday users log workouts, meals, weight, and habit check-ins, then instantly turn that data into pastel-toned bar-graph dashboards. I want the experience to feel frictionless: type once, and every summary page, progress bar, and weekly overview updates automatically without the user touching a formula. Here’s the vision in more detail: • Core modules: fitness, nutrition, weight, and habit logs—each feeding one master “Overall Progress” dashboard. • Visual focus: bar graphs are the primary chart style, but you’re welcome to enhance the story with tasteful line or pie elements where they genuinely add insight. • Design:...

I’m putting together a sleek, gender-neutral tracker that lives both in Excel and Google Sheets. The file will let everyday users log workouts, meals, weight, and habit check-ins, then instantly turn that data into pastel-toned bar-graph dashboards. I want the experience to feel frictionless: type once, and every summary page, progress bar, and weekly overview updates automatically without the user touching a formula. Here’s the vision in more detail: • Core modules: fitness, nutrition, weight, and habit logs—each feeding one master “Overall Progress” dashboard. • Visual focus: bar graphs are the primary chart style, but you’re welcome to enhance the story with tasteful line or pie elements where they genuinely add insight. • Design:...

I need an experienced developer to build a complete Node.js REST API system from scratch that implements GSM and WCDMA telecommunications protocol functionality. You will work with comprehensive protocol documentation to build a production-ready system. What I Will Provide You - Complete protocol documentation (GSM/WCDMA specifications) - Packet format specifications and message type definitions - Device communication requirements (UDP ports, protocol structures) - API endpoint specifications for frontend integration - Protocol examples and sample packet data - Someone to handle device communication (provides JSON format to your APIs) What You Need To Build = 1. Protocol Implementation > PRIORITY Implement GSM protocol (encoding/decoding, message types, validation) Implement WCDMA pr...

We need an automation specialist to build a system that connects our tools and automates repetitive business tasks. The goal is to reduce manual work, improve accuracy, and create reliable workflows across departments. Requirements Workflow design using n8n or Zapier Integration between CRM, email, and spreadsheets Automated lead capture and routing Data syncing between platforms Notification and alert automation Error handling and logging Dashboard for workflow monitoring Testing and documentation

I have an Excel file in my local disk that stores user information in eight columns, and I need a repeatable Power Automate flow that moves this data straight into a Dataverse table. The goal is to eliminate manual data entry completely. Here’s what I already have: • A structured Excel sheet stored in my local disk. • A Dataverse environment with the destination table created and the columns mapped 1-to-1 with the spreadsheet. What I need from you: • Build and configure a Power Automate flow that takes the file, reads every row, and inserts or updates the matching records in Dataverse. • Make sure errors—such as duplicate rows or missing required fields—are handled gracefully with clear email or Teams notifications. • Provide a short walkt...

I have several raw spreadsheets full of customer information and I need them reorganised so they can power clear-cut customer demographics reports. The work involves standardising column headers, cleaning obvious entry errors, merging duplicates, and arranging all records so they flow into pivot tables or other summary views without extra tweaks. My end goal is to open the file, refresh, and instantly see accurate snapshots of age groups, locations, purchase frequency and any other demographic slice that’s already present in the data. A well-structured master sheet plus one or two example reports or dashboards that prove the layout works will be the key deliverables. Feel free to use Excel, Google Sheets or another mainstream spreadsheet tool—as long as the final file is ...

I have a single CSV file that holds all my contact data—name, email, and phone number—and I need it converted into a clean, ready-to-use Excel workbook. The records should appear alphabetically by name, with no extra columns beyond those three essentials. Please apply simple, professional touches such as bold header rows so everything is instantly readable when I open the file in Microsoft Excel. The final deliverable is a .xlsx file that faithfully reproduces every contact from the original CSV while respecting the order and basic formatting notes above.

I need a clean, fool-proof Excel workbook that lets me roster my team by simply typing each person’s start and finish times for every shift. As soon as I enter those times, the sheet must calculate the exact hours worked that day and keep a running total for the week, all without any extra clicks or macros. What has to be captured • Start time and end time for every shift • Hours worked, calculated automatically • A live weekly total for each team member Core requirements • Manual time entry—plain cells where I can type or paste times. • Formulas only (no VBA), compatible with Office 365 and standard desktop Excel. • Clear, protected formula areas so no one overwrites the logic by mistake. • Straightforward layout I can duplica...

I need help to efficiently pair PO numbers with accounts in Excel. Currently, I do this manually using Excel functions, and I'm looking for a more effective solution. Key Tasks: - Analyze current manual process - Develop a streamlined method, potentially using Excel functions, VBA, or other tools Ideal Skills: - Proficiency in Excel, including advanced functions and VBA - Experience in process optimization - Attention to detail and problem-solving skills Looking for a solution that saves time and reduces manual effort.

I have two Excel report sheets and need help merging and comparing data between them. The final output should be a clean, automated dashboard that presents the results clearly.

I have a contacts worksheet in Google Sheet for Mac that often contains more than one row with the same email address. What I need is a lightweight macro I can trigger from a button or shortcut that will: • scan the sheet, • find every email that appears more than once, and • highlight each duplicated entry in red—nothing is to be deleted automatically. The highlight-only approach lets me decide, on a case-by-case basis, which full contact row to keep and which to remove. Aside from the red fill on duplicates, the script must leave every other part of the workbook untouched. Please deliver a ready-to-use VBA module (or an entire macro-enabled workbook if you prefer) that works smoothly in current Mac Google Sheets, along with a short set of installation and usag...

I need three clean, easy-to-reuse templates built in Excel: • A hiring sheet that already has columns for candidate details and position, space to log each interview’s schedule and feedback, and a final section where we record the hiring decision plus any offer details. • A weekly time sheet with rows for employee working hours, break times and any overtime captured automatically. Simple formulas that total the regular and OT hours are a must. • A productivity-hours tracker for my teachers so I can see, at a glance, how many hours each one spends on class time, prep, grading or other tasks; totals should roll up per teacher and per week. * petty cash sheet - incoming money and expenditure items and showing balance as on date * attendane sheet, where i can automati...

I need a Word document converted into an Excel Gantt chart. Key requirements: - Tasks and deadlines to be transferred - Organized by project phase - Color-coding for phases (if needed) Ideal skills and experience: - Proficiency in Excel and Gantt charts - Attention to detail - Experience with Word and task organization

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

My workbook already contains a sizable VBA routine that keeps our day-to-day data flowing, yet it now throws occasional errors, runs slower than it should, and is missing a few purpose-built functions that would save even more time. I need the codebase tuned rather than rebuilt: squash the bugs, streamline the logic so it executes faster, and insert several new user-defined functions that handle repetitive steps I still perform manually. You will receive the current file with full source code and a short list of the extra tasks these new functions must cover. Please keep the structure familiar, add clear comments, and avoid breaking existing naming conventions so future tweaks remain simple. Deliverables • Clean, fully tested VBA module(s) with all errors resolved • Perform...

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

I have 50 pages of information locked in PDF documents that I now need clearly entered into a single Excel workbook. Nothing fancy—just clean, error-free data that mirrors what you see on each page. Accuracy matters more than speed; a small typo in one cell could throw off the entire file, so I need someone who is comfortable double-checking their own work and flagging anything that looks ambiguous. Once you receive the PDFs, please extract every data point and lay it out row-by-row in Excel so I can sort, filter, and run formulas later. If a page has obvious column structure, keep that structure intact. If it’s a paragraph or form, split the content logically across columns (I can clarify edge cases as they come up). No special template is required—the standard grid is ...

I’m looking to acquire two complete, tutor-led courses that I can upload directly to our learning-management system: • A 7-hour Power BI program that dives deeply into Data Visualization—covering everything from choosing the right chart to designing interactive dashboards and publishing them to Power BI Service. • A 10-hour Advanced Excel program that takes a truly comprehensive approach, weaving together advanced formulas, dynamic arrays, pivot-based analysis, and the day-to-day tricks professionals rely on. Both courses must already be fully recorded in HD video with clear audio and on-screen demonstrations. I’ll need the accompanying syllabus, exercise files, assessments (if available), and the licensing terms that allow us to host the content on our priva...

Project Description for Excel Expert ​Project Goal: I am looking for an Excel Expert to help me organize and automate my data effectively. ​Data Cleaning: The freelancer must clean raw data, remove duplicates, and fix formatting issues. ​Advanced Formulas: Expert knowledge of formulas like VLOOKUP, HLOOKUP, XLOOKUP, and INDEX-MATCH is required. ​Pivot Tables: Ability to create dynamic Pivot Tables and Charts for data summarization. ​Automation (VBA/Macros): I need someone who can create Macros or use VBA to automate repetitive tasks. ​Dashboard Creation: Looking for a clean and professional interactive dashboard to visualize key metrics. ​Data Accuracy: High attention to detail is a must to ensure 100% accuracy in calculations. ​Data Validation: Setting up drop-down lists and data validati...

I need a solid, one-week turnaround on a VBA solution inside Microsoft Access that links our on-premise Horizon MRP Plus database to the cloud-hosted Easy System platform (). The goal is full invoice-data automation: pull the records from Horizon, transform them to the JSON schema required by Easy System, then push and retrieve them through an SFTP endpoint. All work happens inside an existing Access front-end—tables, queries, and forms are already in place, and I can share the current VBA modules that handle local processing. What is missing is the external hand-off and the return feed, plus robust logging so accounting can see exactly what went out and what came back. Key points you’ll tackle: • Write or extend VBA routines that assemble invoice headers, line items, an...

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

I’m putting together a sleek, gender-neutral tracker that lives both in Excel and Google Sheets. The file will let everyday users log workouts, meals, weight, and habit check-ins, then instantly turn that data into pastel-toned bar-graph dashboards. I want the experience to feel frictionless: type once, and every summary page, progress bar, and weekly overview updates automatically without the user touching a formula. Here’s the vision in more detail: • Core modules: fitness, nutrition, weight, and habit logs—each feeding one master “Overall Progress” dashboard. • Visual focus: bar graphs are the primary chart style, but you’re welcome to enhance the story with tasteful line or pie elements where they genuinely add insight. • Design:...

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 need a simple, reliable VBA macro that scans an Excel workbook and replaces specific words only—no pattern matching or regex, just straight one-to-one swaps. The list of target words and their replacements will already be laid out for you across multiple columns in a dedicated sheet; the macro should read directly from that sheet, loop through the rest of the workbook, and make the substitutions wherever they occur. Key points you should build in: • Action: word-for-word replacement (this is a data-processing task, not data entry or extraction). • Source list: multiple columns on a single sheet; assume column A holds the words to find and column B the words to insert. • Scope: apply changes to every cell in every sheet unless I later flag specific sheets to ex...

I need a lightweight Excel-based “project program” that I can open, understand and tweak without outside help. Everything—from the way data is entered to the formulas that calculate results—has to stay clear, unlocked, and easy to adjust. Here’s the feel I’m after: I type project details in one place, watch totals or status indicators update instantly, and know I can add rows or columns later without breaking anything. Macros, pivot tables or flashy charts are fine only if they remain transparent; the priority is simplicity and self-sufficiency. What I’d like back from you is an .xlsx file with: • A clean data-entry sheet • Built-in calculations clearly labeled or commented • A concise note or inline comments pointing out whe...

I’m building a streamlined payroll workbook in Excel that handles everything in one place—from manual attendance entry right through to the final net-pay figure. The file must automatically calculate basic salary, overtime, incentives, standard and optional deductions (PF, ESI, TDS), then roll these up into clear per-employee and month-end summaries. Key expectations • Robust formulas or VBA (your call) that protect against common data-entry errors and flag them instantly. • A clean, intuitive attendance tab designed for manual input; once entries are made, every other sheet should update without further touch-points. • Consolidated reports that let me see totals, breakdowns and variances at a glance. Deliverables 1. Finished Excel workbook with all...

Project Overview We are building an Excel-based automation and reporting system to track execution progress and speed across two parallel workflows: Listing optimization: - PPC advertising pipeline - The system must show status, velocity, bottlenecks, and readiness on ASIN and Cluster level, both internally and client-facing. This is a system-level automation project, not a simple dashboard. What the System Must Do: At any time, the reporting must clearly answer: - Where do we stand overall? - Which clusters are blocked or slow? - How fast is execution moving? - Is Listing or PPC the bottleneck? - How has progress changed vs yesterday / last week / last month? Core Scope (High-Level): - Derive execution statuses from raw Excel data - Track daily historical snapshots (append-only) - Cal...

Monthly sales figures from several CSV exports have to be transformed into clear, actionable insights in Excel. The core of this Excel-based project is data analysis, not general spreadsheet creation or macro automation, so the focus stays on cleaning raw sales data, structuring it, and presenting digestible results. Scope of work • Import and consolidate all source files into a single, well-organized workbook. • Remove duplicates, handle missing values, and standardize date and currency formats. • Build dynamic pivot tables, slicers, and charts that let me filter by product line, region, and time period. • Generate a concise dashboard highlighting total revenue, average order value, month-over-month growth, and top-performing SKUs. • Provide a short writt...

Monthly sales figures from several CSV exports have to be transformed into clear, actionable insights in Excel. The core of this Excel-based project is data analysis, not general spreadsheet creation or macro automation, so the focus stays on cleaning raw sales data, structuring it, and presenting digestible results. Scope of work • Import and consolidate all source files into a single, well-organized workbook. • Remove duplicates, handle missing values, and standardize date and currency formats. • Build dynamic pivot tables, slicers, and charts that let me filter by product line, region, and time period. • Generate a concise dashboard highlighting total revenue, average order value, month-over-month growth, and top-performing SKUs. • Provide a short writt...

I have a collection of raw records that must be transformed into a clean, structured Excel / CSV database. Your task is to take the source material I provide—scans, PDFs, or text files—and enter each data point accurately into the correct columns, double-checking for consistency, spelling, and formatting along the way. Key points: • Work directly in Excel or any CSV-compatible tool you prefer. • Follow the field order and naming conventions I will share so the final file can be imported into my main system without tweaks. • Spot and flag any missing or conflicting information; I’ll clarify quickly. • Deliver the completed spreadsheet plus a brief log noting totals, issues found, and any assumptions you had to make. I value precision and on-time...

Excel Macro Conversion & Redesign (Windows → Mac / Excel or Numbers) I am looking for an experienced Excel expert to adapt an existing Excel file with macros, originally built on Windows, so it can be used seamlessly on Mac or alternatively converted to Apple Numbers, while preserving full functionality. Scope of work: • Adapt or rewrite Excel VBA macros so they work perfectly on Mac Excel, or provide a reliable solution using Apple Numbers • Ensure all formulas, calculations, and automated processes work exactly as intended • Optimize performance and stability across platforms • Redesign the layout to make the document more modern, visually appealing, and user-friendly • Maintain and properly integrate existing images, charts, and formatting Proje...

I need three clean, easy-to-reuse templates built in Excel: • A hiring sheet that already has columns for candidate details and position, space to log each interview’s schedule and feedback, and a final section where we record the hiring decision plus any offer details. • A weekly time sheet with rows for employee working hours, break times and any overtime captured automatically. Simple formulas that total the regular and OT hours are a must. • A productivity-hours tracker for my teachers so I can see, at a glance, how many hours each one spends on class time, prep, grading or other tasks; totals should roll up per teacher and per week. * petty cash sheet - incoming money and expenditure items and showing balance as on date * attendane sheet, where i can automati...

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, Python, 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 temp...

I have an interior-design package that now needs to move from concept to a coordinated, presentation-ready set of documents. My priorities are clear: • Clash-free shop drawings in both DWG and PDF that cover Furniture Layout, Electrical Plans, and Plumbing Layout. The drawings only need a basic-overview level of detail—enough for the fit-out team to see intent, dimensions, and service routes without getting lost in micro-detailing. • A Quantity Survey workbook in Excel with open formulas so anyone can audit the math, plus obvious measurement references that trace back to the drawing sheets. • Regular extracts—monthly or tied to agreed milestones—that reconcile the original BOQ with completed work. I’ll need those in Excel and PDF. • Unifor...

I have an interior-design package that now needs to move from concept to a coordinated, presentation-ready set of documents. My priorities are clear: • Clash-free shop drawings in both DWG and PDF that cover Furniture Layout, Electrical Plans, and Plumbing Layout. The drawings only need a basic-overview level of detail—enough for the fit-out team to see intent, dimensions, and service routes without getting lost in micro-detailing. • A Quantity Survey workbook in Excel with open formulas so anyone can audit the math, plus obvious measurement references that trace back to the drawing sheets. • Regular extracts—monthly or tied to agreed milestones—that reconcile the original BOQ with completed work. I’ll need those in Excel and PDF. • Unifor...

I need a polished, interactive dashboard in power bi that lets me track monthly consumption while also comparing related expenditure and production figures. The raw data will come to you in simple spreadsheets; once I paste the latest month’s numbers, the dashboard should refresh automatically and update every chart, table, and KPI. Here is what I expect: • One interactive front-page that uses slicers or drop-downs so I can flip between different years, individual months, or the full year-to-date view. • Dynamic charts and graphs for each metric—consumption, expenditure, and production—plus an at-a-glance section showing totals, variances from the previous month, and year-to-date figures. • Supporting tables beneath or behind the visuals so I can d...

I need a streamlined way to record every inward and outward movement of stock so that my running balance is always accurate. The only details I want captured are the product name and its quantity; anything more slows my team down. My preference is to work in MS Excel because everyone here already uses it daily, yet the final sheet must be formatted so it can feed data into our existing custom billing software that issues GST invoices and e-way bills for wholesale orders. A clean CSV export or a lightweight macro that pushes the figures across will do the job—whichever you feel is the quickest to maintain. Deliverables • A ready-to-use Excel workbook with clearly separated inward, outward, and live-stock sheets, plus built-in checks that flag negative or mismatched quanti...

I have an Excel workbook that needs to turn whatever I type into structured, print-ready Reports. The idea is simple: I enter data on one sheet and, through well-planned formulas (and any clever use of named ranges or dynamic print areas you think is best), the file instantly reshapes that information into a polished layout that is ready to hit Ctrl-P without further tweaks. Content focus The Reports are meant to hold Documentations, yet I want enough flexibility so that later I can extend them to other sections such as Sales data, Employee performance or Inventory levels if needed. Please keep the formulas and any conditional formatting readable because I will maintain the file after your hand-off. What I expect as deliverables • A single .xlsx template with all formulas, page ...

I have a plain-text data file that needs to land in Excel as a fixed-width import, but it is full of invisible tab characters that keep throwing the column breaks off. All I need is a clean version of the file with every single tab removed—no re-formatting, no re-ordering. The finished text will line up neatly into roughly 5-10 fixed-width columns once I bring it into Excel. Feel free to use whatever text-editing environment or quick script you prefer; I simply open the file in an editor other than Notepad/Notepad++. The only requirement is that the output contains the exact same lines and spacing minus the tab characters. Deliverables • A tab-free .txt file ready for fixed-width import • A brief note (one or two lines) confirming what you did so I can replicate the p...

I need my Tally data presented through fully customised reports that look polished and calculate key figures on their own. Beyond the standard layouts, every report has to follow a precise page setup, column arrangement, headers, colours, and fonts that I will provide. Derived metrics—ratios, variances, running totals, margins—must populate automatically whenever the underlying vouchers change, so manual edits disappear entirely. You may work in pure TDL, TallyPrime’s built-in designer, ODBC links to Excel, or any blend that delivers a single-click refresh and lets me export to PDF and XLS without the formatting breaking. I’ll hand over a company backup, sample printouts, and a short style guide at kickoff, along with the exact calculation rules. Deliverables &bul...

Goal: Create a high-performance Excel dashboard for an audit tracker with 17k+ rows that is fully functional when shared via a OneDrive/SharePoint link. Key Technical Requirements: Data Connection: Use Power Query to import the source data. Include a transformation step to "Trim" all text columns (to fix the trailing spaces in Vendor names and Statuses). Performance Calculation: Add a custom column in Power Query to calculate "Aging" (Days from 'Date' to 'Closure Date'). If 'Status' is Pending, use TODAY() for the end date. Interactivity (Web-Ready): Do not use VBA/Macros for the dashboard navigation. Use Slicers connected to all Pivot Charts. Required Visuals: Monthly Trend Line: Count of observations by month. Vendor Comparison: Ba...

I need a sharp MIS hand to take raw operational data and turn it into clear, decision-ready information. Day to day you’ll work in Excel, mining the sheets I supply, then translating them into reports that management can read at a glance. Beyond the routine summaries, I also want fresh insight—spotting patterns, highlighting anomalies, and presenting concise trend analysis that guides our next moves. Core focus areas • Generating reports in clean, well-formatted Excel workbooks • Performing trend analysis that combines numbers with brief narrative takeaways Consistency, accuracy, and visually intuitive charts are non-negotiable. If you prefer adding Power Query, pivot tables, or VBA to streamline the flow, feel free; just keep everything compatible with standa...

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

I need my Excel workbook opened up so I can finally see and edit everything inside it. The file is currently locked at the workbook level and its VBA project is also password-protected. I don’t need you to alter, optimise, or add any macros—just remove the protection cleanly, preserve the existing code and data exactly as they are, and send the unlocked version back to me. Deliverable: one fully accessible workbook with all workbook and VBA passwords completely removed, ready for me to work on without any prompts.

I need a robust yet straightforward way to pull equity and option-chain information from Massive, Yahoo Finance, or any other reliable market data API you propose, and deliver it straight into my Excel model (or a clean CSV that drops in seamlessly). The data set must include: • Historical OHLC prices and volume • Key market statistics such as market-cap, short interest, basic fundamentals • Full options chains with greeks when available I have no hard preference on the raw download format—as long as the end result is refreshable in Excel without manual clean-up. What I expect from you 1. A well-commented script or low-maintenance workflow (Python, VBA, Power Query, or similar) that authenticates, fetches, and aggregates the fields above. 2. Mapping lo...

• Add the entire Remnant classmod into a new, separate sheet tab so no existing data or formulas are overwritten. • Follow the formatting conventions already used in other classmod tabs (fonts, borders, color coding, layout). • Create unique named ranges for all Remnant values, features, and scaling tables to avoid conflicts with existing classes. • Do not modify or delete any existing formulas, scripts, triggers, or backend tabs unless explicitly told to. • Keep all new formulas isolated to the Remnant tab or a dedicated backend tab; avoid embedding new logic into core sheets. • Link Remnant data to the main character sheet using pull formulas (e.g., VLOOKUP, INDEX/MATCH) instead of altering core logic. • Ensure Remnant integrates cleanly with lev...