Visual Basic Jobs

I have a raw set of customer records that must move from messy spreadsheets to a structured, analysis-ready format. The job starts in Excel—think Power Query, advanced formulas, or VBA for quick wins—then shifts to Python (Pandas, NumPy, openpyxl) so the process can run automatically whenever fresh data arrives. Here’s what I need from you: first, clean and normalise the fields (remove duplicates, unify date and address formats, fill or flag missing values). Next, reshape the information into tidy tables that feed our reporting model. Finally, package everything into a repeatable Python script that reads the latest file, runs the full transformation pipeline, and exports polished XLSX/CSV outputs along with a simple log of what changed. Deliverables • One fully d...

I have a small sales dataset that needs to be transformed into a clear, at-a-glance dashboard in Excel. Here is exactly what I’m after: • Re-organize the raw data into a tidy, structured table that will be easy for me to update later. • Calculate and display three headline figures—Total sales, Number of transactions, and Average sale value—so they stand out immediately. • Create a concise summary panel that pulls those key numbers together. • Add one straightforward Pie chart to visualise the breakdown of sales. • Keep everything on a single, well-formatted worksheet so colleagues can open the file and understand it instantly. All formulas should be transparent and editable; please avoid hard-coding. When finished, simply send me the Exc...

I have a raw set of customer records that must move from messy spreadsheets to a structured, analysis-ready format. The job starts in Excel—think Power Query, advanced formulas, or VBA for quick wins—then shifts to Python (Pandas, NumPy, openpyxl) so the process can run automatically whenever fresh data arrives. Here’s what I need from you: first, clean and normalise the fields (remove duplicates, unify date and address formats, fill or flag missing values). Next, reshape the information into tidy tables that feed our reporting model. Finally, package everything into a repeatable Python script that reads the latest file, runs the full transformation pipeline, and exports polished XLSX/CSV outputs along with a simple log of what changed. Deliverables • One fully d...

Our raw-material stock ledger lives in a handful of aging spreadsheets, and they no longer keep pace with daily production demands. I need an Inventory Data Specialist who can take charge of two core responsibilities: first, keeping every line item current, accurate, and duplication-free; second, turning that cleaned data into concise, decision-ready reports. The job revolves around manual spreadsheets only—no ERP or dedicated inventory software in place yet—so strong command of Excel or Google Sheets (functions, lookups, pivot tables, conditional formatting, error checking) is essential. Raw materials range from basic commodities to specialty inputs, each tracked by SKU, lot, and expiry date. What success looks like • A single, master spreadsheet that replaces scatter...

I need an interactive Power BI dashboard built from Excel/CSV exports that I’ll provide. The sole focus is customer engagement, so the model and visuals should surface churn, retention, active-user trends, session frequency, and any other insight you recommend for quickly reading engagement health. You’ll connect the flat files, shape them in Power Query, build a clear data model, write the DAX needed for metrics and time intelligence, and design a clean, uncluttered layout that works on both desktop and the Power BI Service. The report must refresh seamlessly whenever I replace the source files and come with a short note explaining tables, relationships, and calculated measures so I can extend it later. Deliverables: • Finished .pbix file with the customer-engagement da...

We are looking for talented female freelancers with strong knowledge and experience in WooCommerce, website development, UI/UX design, and web design to help take our website to the next level. The ideal candidate should have a proven track record in creating engaging, user-friendly websites, optimizing site performance, and implementing modern web design trends. Skills & Expertise Required: WooCommerce setup, customization, and optimization UI/UX design for web and mobile interfaces Website development (front-end and back-end) Graphic design, layout, and visual storytelling for web Knowledge of responsive design, SEO, and website speed optimization Ability to implement plugins, themes, and e-commerce functionalities Responsibilities: Enhance and modernize our website for bett...

I need a clean, professional‐looking Excel dashboard dedicated to financial analysis, with the emphasis on budget forecasting. All underlying sheets are ready; what’s missing is an intuitive front-end that lets me monitor how actual spending measures up against projected figures at a glance. The heart of the job is visual: I want clear, well-labeled graphs and charts that summarise monthly, quarterly and year-to-date performance. Think dynamic column charts for variance, simple line charts for trends and perhaps a waterfall to show cumulative impact—whatever conveys the story best. Everything must update automatically as fresh data is pasted into the source tables. You are free to use the Excel tools you prefer—PivotTables, named ranges, Power Query, slicers, even a...

I need all mixed data—numbers and text—lifted accurately from a PDF and placed into Google Sheets. Once the transfer is complete, I expect advanced formatting: formulas where they add value and conditional formatting set up to highlight any duplicate entries automatically. Deliverables: • A Google Sheet populated with every record from the PDF, checked for integrity • Conditional-formatting rule that flags duplicates clearly • Any supporting formulas documented in-cell or with a brief note so I can tweak them later Attention to detail is critical; the sheet should be ready for immediate analysis the moment you hand it back.

I’m looking for a lightweight yet robust set of templates built only in Excel and Word. The first deliverable—and my main focus right now—is a project tracker I can update myself after hand-over. It must let me assign tasks, follow progress, and flag upcoming deadlines. I want the same information surfaced three ways: • a clean table for quick data entry, • an at-a-glance dashboard, and • a simple Gantt-style timeline. Formulas, conditional formatting, slicers, and data validation are fine; no VBA or other code. I also need journey-map, Kanban, templates. Deliverables – One Excel workbook linking the table, dashboard, and Gantt views. – A concise Word guide explaining how to add tasks, adjust dates, and toggle reminders. Acce...

I will turn your raw business data into a clean, reliable model and then build a modern Power BI—or, if you prefer, Excel—dashboard around it. Using SQL and Power Query I’ll handle the full preparation pipeline so every refresh runs automatically. The finished dashboard will surface your key sales, order, and performance indicators through intuitive charts, drill-through views, and slicers that non-technical users can explore with confidence. Colour palette, fonts, and layout will match your brand, and advanced filters will let you zero in on any segment or period in seconds. Deliverables • PBIX (or XLSX) file with documented queries and DAX formulas • Fully interactive report pages, mobile-friendly layout included • One-click refresh connection t...

I need an engaging trainer who can take absolute beginners through the fundamentals of data analysis in a series of online live sessions. The audience has no prior experience, so the material needs to start from scratch—explaining core concepts, demonstrating workflows step by step, and giving plenty of hands-on practice. We will meet over a video-conferencing platform (Zoom or similar) at agreed times. I expect you to bring a clear syllabus, lively examples drawn from real datasets, and interactive exercises that let participants follow along on their own machines. Recordings of each session, slide decks, and any code or spreadsheet templates you use should be shared afterward so the group can review. By the end of the program, participants should comfortably import raw data, perf...

Create an MS Excel add-in that lets me pull raw tables straight from ERP and excel files, clean the data, explore it visually, and push out polished, reusable reports—all without leaving the Excel worksheet. Core functionality I need built in: • Connectivity to ERP tables (ODBC or API—whichever suits Excel best) so a user can browse available tables, apply simple filters, and load the data into a sheet with one click. • Data-cleaning helpers that detect blanks, duplicates, and obvious outliers, then offer quick fixes or flag rows for review. • A visual exploration panel for instant charts and other data-visualization tools so users can slice the imported data on the fly. • A custom report builder where predefined templates pull refreshed figures a...

We are seeking a dedicated and experienced Punjabi language tutor for online lessons. The ideal tutor should be fluent in Punjabi (spoken and written) and able to teach grammar, vocabulary, pronunciation, and conversational skills in a clear and engaging way. Prior teaching experience and a structured approach to lessons are preferred. Requirements: • Strong command of Punjabi • Ability to teach online via video platforms (Zoom, Google Meet, etc.) • Patience and good communication skills • Flexible scheduling options If you are passionate about teaching Punjabi and can provide interactive, personalized lessons, please reach out with your details, availability, and teaching approach.

I’m putting together a personal-finance coaching workbook and need an Excel expert to turn my outline into a polished, user-friendly file. The core of the job is a 12-month layout (January through December) with a clear yearly dashboard that automatically rolls up every figure. Users will open this file on Excel for Office 365 and Excel Online, so every formula, table, and link has to behave perfectly in those environments and display well on phones as well as desktops. Each monthly sheet should include sections for Income (broken down into Salary/Wages, Investments, and Other Income), Expenses, and an at-a-glance Net Total. All totals must flow up to the summary page without complicated array formulas or VBA; simple SUM, SUMIF/SUMIFS, and basic links are fine so clients can audit o...

I need multiple Excel spreadsheets brought together into one clean, automated workbook that updates itself and delivers clear reporting and analysis. The source files hold similar data structures, so the key tasks are to merge them reliably, build VBA macros to refresh the data with one click, and present the consolidated figures in easy-to-read summary sheets. What success looks like • A single master file that pulls from all current and future source sheets without breaking existing formulas • Automated macros that handle data import, de-duplication, and error checking • Well-formatted summary tabs that give me instant insights instead of manual copy-paste work When you reply, focus on the experience you have building comparable Excel solutions—particu...

I want to convert my current Excel file into a simple fleet management system for our bus operations. Right now we are creating a separate sheet for every day’s collection. Instead of that, I want a better structure where we only enter the daily data once and all reports are generated automatically. The system should have one main sheet called DATA ENTRY where we enter the following columns: Date Route No Bus No Driver Conductor Total Collection RFID Collection HSD Litres (diesel filled) Expense From this data Excel should automatically calculate: HSD Cost = HSD Litres × Diesel Rate (currently ₹91) Net Collection = Total Collection − Expense If Net Collection becomes negative, it should automatically appear in red. From the DATA ENTRY sheet I want Excel to automati...

I need a small sales dataset reorganized into a clean, easy-to-read spreadsheet in Excel. After tidying the raw data into a proper table, create a concise summary that highlights total sales—this is the key metric I want front and center. Add a straightforward bar chart so I can see performance at a glance. To succeed, you should be comfortable structuring data in Excel, using formulas to pull totals, and inserting clear, well-labeled charts. The finished file should open to a sheet that immediately shows: • A neatly formatted data table • A summary block with total sales clearly displayed • One bar chart visualizing the figures Keep the layout simple and professional; clarity is more important than complexity. When you’re done, deliver the single Excel ...

Create a quick-invoicing program. for an environmental testing lab; for quick-receipt of payment from walk-in clients. - MS Excel or MS Access. local network or single device storage. - 1 screen "menu" that pulls up existing walk-in customers, or can add new ones. - has a new invoice each time the sheet is opened (preferably sequential, starting with last 2 digits of the year; ie: 2026 = 260001 - 'list' price is added. 'discount' can be added at our company's discretion as an item. - pre-populates an invoice with common services, with customer-specific prices - the services have different priorities (Normal, rush, emergency); think of a restaurant menu of adding 'extra' items to a routine menu item - compile items into an invoice, preferabl...

I have an existing Excel workbook that currently requires manual input of addition, subtraction, multiplication, and division formulas across several sheets. I need these basic arithmetic operations to run automatically as soon as new rows of data are entered, so totals, variances, and ratios update instantly without any further action from me. Please build the automation directly inside the file—VBA, dynamic array formulas, or another native Excel approach is fine as long as it works on both Windows and macOS versions of Office 365 without additional add-ins. Once complete I should be able to drop fresh data into the designated columns and see every calculated field refresh correctly. Deliverables • The updated workbook with the automation in place • A short note...

I need two small Windows utilities built as stand-alone .exe files, each with a simple point-and-click interface (no command line). Utility 1 – Excel-to-Excel re-formatter • I will pass you a source workbook and the target layout “ERP_CONVERTED_2”. • The tool must map every column exactly into that layout, then sort the sheet so that, within each Account No, the Disbursement dates appear first (oldest-to-newest) followed immediately by the corresponding Collection dates. • Finally, the macro should generate a second sheet in the same file called “VITRAN VASULI” that shows a dropdown-driven view arranged Account-wise in the same row order (Disbursement row first, Collection row next or combined when dates match). Utility 2 – PDF-to-...

I have a collection of PDFs containing tables that must be transcribed into a single Google Sheet. Each table holds both text and numerical values, and while many files have just one table, a portion include several that need to be captured separately yet placed in the same worksheet for easy consolidation. Accuracy is critical: every label, figure, and formatting nuance in the source tables should appear exactly the same in the sheet. Keep column order and headings consistent so downstream formulas run without rework. For files with multiple tables, please insert a blank row between each set so I can quickly distinguish them later. I will share the PDFs and an empty Google Sheet with the required header row. When finished, simply notify me—no extra macros or scripts are necessary;...

Project Title: Excel Spreadsheet – Builder Retention Tracking I run a commercial plumbing business in Australia and need an Excel spreadsheet built to track builder retentions across multiple projects. In construction, builders typically hold 5% retention from the contract value. Usually 50% is released at practical completion and the remaining 50% after the defects liability period (typically 12 months). The spreadsheet needs to help us track how much retention is being held, when it should be released, and highlight when payments are overdue. Main Sheet – Retention Register Each row will represent one project. Columns required: Project Number Project Name Builder / Client Contract Value Retention % Total Retention Held (auto calculation) Practical Completion Date...

I need the AIA G702 and G703 application for payment documents recreated in Excel. The final product should be an Excel spreadsheet with custom formulas or calculations as needed. Requirements: - Recreate AIA G702 G703 documents - Deliver as Excel spreadsheets - Include custom formulas as required Ideal Skills and Experience: - Familiarity with AIA documents, particularly G702 and G703 - Proficiency in Excel, especially with custom formulas - Attention to detail and accuracy

I have a batch of information that needs to be keyed in quickly and without errors. The source material and final format are both straightforward, yet I’ll confirm the exact details with you once we connect—whether the records arrive as scans, handwritten pages, or an online pull, the goal remains the same: a clean, organised dataset ready for immediate use. I’m comfortable if you prefer working in Microsoft Excel, Google Sheets, or a lightweight bespoke tool; what matters to me is consistency, correct formatting, and zero duplication. Please let me know your usual turnaround time and the quality-control steps you follow so I’m confident the finished file will be reliable from day one.

I have two bed rooms i need 3d and 3d drawings for excellent looking

Create a quick-invoicing program. for an environmental testing lab; for quick-receipt of payment from walk-in clients. - MS Excel or MS Access. local network or single device storage. - 1 screen "menu" that pulls up existing walk-in customers, or can add new ones. - has a new invoice each time the sheet is opened (preferably sequential, starting with last 2 digits of the year; ie: 2026 = 260001 - 'list' price is added. 'discount' can be added at our company's discretion as an item. - pre-populates an invoice with common services, with customer-specific prices - the services have different priorities (Normal, rush, emergency); think of a restaurant menu of adding 'extra' items to a routine menu item - compile items into an invoice, preferabl...

I need an Excel macro that searches for whole numbers throughout the entire workbook and copies them to another sheet. Requirements: - Search for whole numbers - Operate on the entire workbook - Copy found numbers to a designated sheet - Editable for adding more search criteria

I have a backlog of records that contain both short text descriptions and corresponding numerical figures. They must be transferred quickly and flawlessly into a structured spreadsheet (Excel or Google Sheets is fine) so I can move ahead with analysis straight away. Accuracy is critical—text must be copied exactly as written, numbers must keep their original formatting, and every entry needs to land in the correct column. I will supply the source files and a template with clearly labeled fields the moment we start; I simply need the completed sheet returned, error-free and ready for use, as soon as you can turn it around. If you have a sharp eye for detail, solid data-handling skills, and the bandwidth to begin immediately, let’s get this finished today.

I need a reliable, easy-to-update forecast for medication supplies that tells me two things at a glance: how much stock I will need and when each batch will expire. I already have partial historical demand figures that you can build on; what I lack is a clean, formula-driven model that projects future requirements with confidence. Please use Excel or Google Sheets—whichever you feel gives the clearest, most maintainable formulas. The sheet should automatically pull forward the remaining stock, apply average or weighted consumption rates from my partial data, flag upcoming expiries, and highlight any shortfalls before they happen. If there’s a smarter way to visualise this, feel free to include a dashboard, but the core deliverable is the working set of formulas. Acceptance cr...

I need a simple Excel program to track customer scoring daily for a calendar month. Requirements: - Track customer scoring (1-100%) for each day - Manual data entry - Include graphs/charts for data visualization Ideal Skills: - Proficient in Excel - Experience with data visualization in Excel

I need a quick Power Automate flow that takes specific information arriving in Outlook and drops it into a separate Excel workbook, matching the first line of the body of the email with the name on the spreadsheet, and inputting a YES on a third column if the names match. The sole purpose is to remove manual data entry, so the flow only has to watch a dedicated folder, parse the required fields from each message, and append them to the target spreadsheet stored in OneDrive or SharePoint. The logic should be straightforward: • Trigger: email already stored in the outlook Outlook folder • Action: extract the client name • Destination: enter a "yes" in a new column if the extracted name matches the name present on the spreadsheet The complexity lays in the way th...

I need a rolling Excel spreadsheet with the following features: - Data Entry and Validation - Automated Calculations (Sum and Averages) - Manual Input for Data Sourcing Ideal Skills and Experience: - Proficiency in Excel - Experience with Data Validation and Automated Calculations - Attention to Detail and Accuracy Looking for someone to create a user-friendly, efficient spreadsheet. 14 tabs with a corporate total page

I need a secure Android banking app built from the ground up for Arab Bank. The core scope is clear: users must be able to manage their accounts, transfer funds, and pay bills effortlessly from their phones. To make this happen, I’ll supply API documentation for our core-banking system along with brand guidelines and sample data. Your task is to design and code the full mobile experience—clean UI, solid architecture, and encrypted communication throughout. Performance, accessibility, and regulatory compliance (PCI-DSS level practices) are non-negotiable. Deliverables • Fully functional Android app (latest stable SDK) • Source code in Git, well-commented and neatly structured • UI/UX assets (Figma or similar) • Integration layer that consumes our ...

I need a clean, well-structured Excel workbook that will automatically calculate our storage fees at $0.60 per cubic foot. I’ll supply the raw numbers as cubic feet per line item, spanning more than 10 different organizations, so the file must scale gracefully. Workbook requirements • A data sheet where I can paste or import the monthly cubic-foot figures per line item. • Formulas that multiply each entry by 0.60 to generate the charge, then roll those charges up:  - by line item and organization for each month,  - into directorate-level totals for the same period. • Pivot tables that let me view charges month-by-month for every organization and its individual line items, plus a grand-total row for each directorate. • An additional pivot (or...

I have several Excel spreadsheets that need to be keyed into our system by hand. Everything is already organized in clear columns and rows; no importing scripts or macros are required—this is purely manual data entry. Your task is to read each cell, verify the value is complete and legible, then enter it into the web-based form I provide. Accuracy is critical, so I will run spot checks after each batch. I will share the first sheet as a sample; once that is confirmed correct, the remaining files will follow in groups of five. Deliverable • Completed web forms (or CSV export from the form tool) for every row in the supplied spreadsheets, returned in the same order as the source files. Acceptance criteria • 99%+ accuracy on spot-checked fields • All mandatory f...

I’m spending far too much time re-typing purchase vouchers into Tally when everything is already organised in Excel. I need a small utility that reads those spreadsheets and posts each row as a purchase entry in my Tally company, with all taxes, supplier details and inventory lines carried over exactly as they appear in the sheet. You are free to choose the most efficient route—Tally XML import, ODBC, TDL, or a Python/.NET bridge—so long as the final result is a one-click (or near one-click) process that any non-technical staff member can run on a Windows machine. Deliverables • Executable tool or script with a simple UI or clear command-line instructions • Mapping configuration so I can point new spreadsheet layouts to the correct Tally fields without cod...

I’m looking to lock in a reliable baseline schedule for an upcoming project so I can measure progress against a fixed set of dates right from day one. The focus is a project-level timeline presented as a Gantt chart, detailed enough to highlight every key milestone without drilling all the way down into individual task subtasks. Here’s what I need: • A complete Gantt chart that maps the full project duration, major phases, and clearly defined milestones (with start, finish, and baseline dates). • Logical sequencing with dependencies called out so the critical path is obvious at a glance. • A baseline saved alongside the live schedule so variance tracking is effortless later on. • Editable source file—MS Project, Excel, or another mainstream too...

I need all mixed data—numbers and text—lifted accurately from a PDF and placed into Google Sheets. Once the transfer is complete, I expect advanced formatting: formulas where they add value and conditional formatting set up to highlight any duplicate entries automatically. Deliverables: • A Google Sheet populated with every record from the PDF, checked for integrity • Conditional-formatting rule that flags duplicates clearly • Any supporting formulas documented in-cell or with a brief note so I can tweak them later Attention to detail is critical; the sheet should be ready for immediate analysis the moment you hand it back.

I have a collection of PDFs containing tables that must be transcribed into a single Google Sheet. Each table holds both text and numerical values, and while many files have just one table, a portion include several that need to be captured separately yet placed in the same worksheet for easy consolidation. Accuracy is critical: every label, figure, and formatting nuance in the source tables should appear exactly the same in the sheet. Keep column order and headings consistent so downstream formulas run without rework. For files with multiple tables, please insert a blank row between each set so I can quickly distinguish them later. I will share the PDFs and an empty Google Sheet with the required header row. When finished, simply notify me—no extra macros or scripts are necessary;...

I have between 11 and 20 pages of handwritten notes that must be turned into a clean, well-structured Excel workbook. Every figure, label and annotation from the pages needs to appear in the sheet, and a handful of embedded charts sketched in the margins must be rebuilt with Excel’s native chart tools so the file remains fully editable. Accuracy matters more than speed: spelling, numeric values and any units written in the notes must match what I wrote, and the charts should mirror the original scales, series colours and titles. Please keep the workbook tidy—use clear headings, consistent column widths and chart formatting that looks professional. You can use any version of Microsoft Excel for Windows or Mac as long as the final file opens flawlessly in the current 365 releas...

I have one PDF that contains a series of clearly formatted tables. I need every row and column from those tables transferred accurately into a Google Sheet, preserving the original layout, headings, and cell order. You will receive the PDF as a single file. Your job is simply to open it, copy—or, if you prefer, programmatically extract—the data, and paste or upload it into the sheet I will share. Accuracy is critical; I’ll be double-checking totals, column alignment, and that no rows are missed. Deliverable • A Google Sheet mirroring each table in the PDF, ready for immediate use and further analysis. Acceptance criteria • 100 % of table rows and columns captured. • Original table headings retained. • No extra spacing, merged cells, or forma...

EXCEL RELATED TASK...IN SIMPLE LANGUAGE EK EXE DEVELOP KRNI H APKO AI SE JISME MAX 10 MIN LGENGE JO ME APKO FORMAT FILE DUNGA USKO APKO ERP_CONVERTED_2 WALE FORMAT ME KRNA H ..FIR APKO USME DATE WALE COLUM ME IS TARH KRNA H JO DISBURSEMENT DATE H SAME ACCOUNTS KI WO EK SATH OLDEST TO NEWEST AAE AND COLL KI B ISI TRAH SE AAE FIR APKO ISKO UTILITIY WITH DROPDOWN WALE FORMAT ME VITRAN VASULI KI SHEET WALE FORMAT ME LEKR AANA H OR USME ACC NO WISE AARANGE KRNA H OR SAME ACCOUNT KI JHA DISURSMENT DATE KI ROW H OR COLL YANI KI VITRAN DATE USKE BAAD KI YA SAME H USI ROW ME ARRANGE KRNA H ...EXE ME GUI DE DO OR 2 SE 3 STEP ME KR DO MAXIMUM BUDGET 2000 RS H OR MUJE30 MIN TO 1 HOOUR ME DE DO

see the attached excel dashboard I need the followings: Combine the Address book and task list with following fields: Customer, Contact Person, Phone, Email, Account Manager, Status, Long description. Rename Process Pipeline to Quote Pipeline with the following fields: Quote Type (Active, Expiring), Status (Won, Lost), Reason for Loss

I already run a private AI assistant in-house and now need its answers to come directly from our own material. I have chosen Pinecone as the vector store and will start by loading several Excel spreadsheets that contain operating procedures, KPIs and reference tables. The single most important outcome is lightning-fast information retrieval when staff query the bot; analytics, reports, and other add-ons can wait until phase two. Here’s what I need you to do: • Build a clean ingestion pipeline that takes our Excel files, splits them sensibly (sheet, row or custom logic), converts the text to embeddings, and writes everything to a Pinecone index. • Wire up a basic retrieval function (Python / LangChain or similar) that the chatbot can call, returning the most relevant co...

I have several years’ worth of appraisal data currently scattered across multiple CSV and TXT files. The goal of this project is to collect that raw information, move it into a clean Microsoft Access back-end, and then give me simple, point-and-click ways to work with it every day. Core objectives • Build the Access tables from my existing CSV/TXT files • Design friendly forms so I can review, edit, and manage the records without touching the tables directly • Enable one-click exports that feed the data into Excel, produce mail-merge ready form letters, or create custom on-screen/printable reports Technical notes • Source files are standard comma-delimited and tab-delimited text or other • Front-end can be Access or an Excel interface, as long as it...

Our entire pricing catalogue currently sits in a single Excel workbook, but we have a new CMS system that contains a new spreadsheet structure that will serve as the future-proof version of our pricing system. I need every element moved across—product and service descriptions, image links, materials, equipment, labour rates, and any related look-ups—while reshaping the data to fit the new column order, field names, and calculation logic that lives in our new program. Because the new template differs from the old one, this is more than a simple copy-and-paste job; it calls for significant data transformation. You may need to: • split or merge fields, • convert formulas into more efficient functions, • normalise units and naming conventions, and • ...

**Title:** Need Expert to Create Critical Path Method (CPM) Schedule in Excel for Construction Project **Description:** I’m looking for an experienced construction planning professional who can create a **Critical Path Method (CPM) project schedule** for a construction project using **Microsoft Excel**. The goal is to clearly map the **entire project timeline**, dependencies between activities, and the **estimated completion time for each stage of the project**. **Scope of Work:** • Create a **complete CPM schedule** for a construction project • Provide **activity breakdown (tasks and sub-tasks)** for the project • Show **start date, finish date, duration, and dependencies** for each activity • Identify the **critical path** clearly • Calculate **total p...

I need a robust Excel model that focuses on revenue projections for a short-term rental / Airbnb portfolio. The spreadsheet should let me plug in nightly rates, expected occupancy, and seasonal adjustments so I can see monthly and annual revenue at a glance. Key elements to build in • Seasonal variations – automatic high, shoulder, and low-season multipliers • Occupancy rates – editable assumptions down to individual property, with a summary dashboard • Pricing strategies – side-by-side scenarios for static, dynamic, and minimum-stay pricing Please structure the workbook so I can easily add properties, change assumptions, and export clean PDF reports for investors. Charts that visualise ADR, RevPAR, and total income over time will be helpful, but...

I am putting together a comprehensive inventory-management report that draws on several different raw data sources and I need your help building it in Advance Excel, enhancing it with Macros/VBA automation, and visualising the results in Power BI. Here is what I have in mind. Multiple CSV and spreadsheet feeds will be consolidated, cleaned and reshaped inside Excel. Macros or VBA routines should automate the refresh and mapping process so I can drop new files into a folder and have the workbook update itself without manual intervention. From there, the prepared tables need to flow into a Power BI model that produces an at-a-glance dashboard highlighting current stock levels, inbound and outbound movements, and any exceptions that require action. I will supply sample data so you can design...

Each week I’ll send you a fresh export of our inventory data straight from the ERP. Your job is to turn that raw sheet into an easy-to-digest story in both Excel and Power BI. Here is what I’m after: • In Excel: a cleaned, well-structured workbook with dynamic tables, formulas or Power Query steps that let me drop in the new file and refresh. Pivot tables and slicers should make it effortless for me to drill down by SKU, warehouse and ageing bucket. • In Power BI: an interactive dashboard that mirrors the Excel logic but adds richer visuals—bar charts, pie charts, line graphs and any other view you feel best highlights stock movement, excess, and potential shortages. The report needs to refresh from the same data source I provide and should be easy for me t...