Visual Basic Jobs

I need help transferring numerical data that currently lives in a company database into clean, well-structured Excel spreadsheets. The task is straightforward: open the records I will grant you access to, verify each figure against the on-screen source, then enter it accurately into the matching Excel fields I provide. Consistency is crucial, so a quick eye for spotting outliers or missing values will be appreciated. I will supply clear field-by-field guidelines and a small sample sheet so you can see the desired formatting before you begin. A short check-in after the first batch will confirm we’re aligned, then you can proceed with the remaining rows. If you have solid experience with data entry, understand basic database navigation, and are comfortable working in Excel, this ...

I need an execl spreadsheet wizard that can combine multiple independent estimates of multiple types of contracts ( with multiple years and the job description with amounts of people) into one large spreadsheet spread out over a ten year with a summary page. To handle multiple contract types, headcounts, job descriptions, and a ten-year timeline without creating an unmanageable mess, we must separate your data into three distinct layers: Data Inputs, the Calculation Engine, and the Executive is the blueprint for your master spreadsheet. 1. The Core Architecture[Input Sheets] ---------> [Master Calculation Sheet] ---------> [Dashboard / Summary] - Contract Type A - Combines all inputs - 10-Year Financial Chart - Contract Type B - Standardizes timeline...

I need a rigorous value-based pricing framework and an accompanying ROI model for the Herdwatch Enterprise Platform. Because the platform is rooted in agriculture, the model has to speak the language of farm managers and ag-tech procurement teams, proving in clear numbers how much time our software saves them each week and what that is worth in monetary terms. Here is what I expect: • Pricing framework: a structure I can reuse to set customer-specific licence fees that scale with measured time savings. The framework should show how to move from raw usage or operational data to € value created and finally to the price point, allowing a simple “plug-in” of each prospect’s metrics. • ROI calculator: built in Excel, with clean formulas, inputs clearly sep...

I'm looking for a PowerBI expert to create an interactive and insightful report page using data from Excel spreadsheets. The visuals should help in analyzing spend data and can be filtered and sliced by Matter, Region, Department, and Paid Date (with options to filter by quarter and year). Requirements: - Visuals should include, but not limited to: Bar charts, Pie charts, Line graphs, etc., depending on what best displays the data. - Key metrics to be included: Total Spend, Total Spend per Quarter, Total Spend by Year, Spend by Department - The report should be user-friendly and allow for easy data exploration Ideal Skills and Experience: - Proficiency in PowerBI and Excel - Strong data visualization skills - Experience with spend analysis reports - Ability to create interactive fil...

My current CSV contains value misalignment and inconsistent date formatting that are breaking downstream reports. I need someone who can open the file, identify every row where a cell has slipped into the wrong column, and realign the data so each field sits in its correct place. While you are in there, please standardise all date fields to a single, clean format (ISO-style yyyy-mm-dd is fine) and remove any delimiter or line-break quirks that could trip up future imports. You may use whatever parsing or spreadsheet tools you prefer, as long as the final deliverable is a single, well-structured CSV that opens flawlessly and preserves every record exactly once. Before handing it back, spot-check totals or unique IDs so we both know nothing was lost or duplicated. Deliverable: • Clean...

I need an Advanced Excel specialist to turn raw campaign data into an interactive retention dashboard that spotlights performance metrics—specifically conversion rates. My files already contain the necessary transactional and engagement logs; what I’m missing is a clean, automated way to track how each cohort converts over time and to surface insights I can act on immediately. Here’s what the finished work should let me do: • Open one workbook and, through slicers or drop-downs, filter by channel, segment, or date range to see real-time conversion performance. • Compare current conversion rates against historical benchmarks, with clear visual cues when a metric slips or surpasses target. • Drill down from a summary view to individual campaign detail...

I need a well-structured Excel workbook that lets me drop in raw customer data and instantly see meaningful insights. The core objective is data analysis focused specifically on customer behaviour, so the file should make trend analysis and segmentation analysis both quick and intuitive. Here is what I have in mind: • A clean, instruction tab where I can paste or import new customer records (CSV friendly). • Automated tables, formulas, or Power Query steps that transform that raw feed into an analysis-ready data model. • Pivot tables, charts, or a compact dashboard that highlights purchase trends over time and breaks the customer base into clear segments I can act on. • Everything unlocked and documented so I can tweak filters, date ranges, or add new fields la...

I’m putting together a three-hour Excel workshop for an Information Technology team of roughly 15–20 people and I need a complete training package that hits both basic and intermediate skills. The focus is on practical ability, so every concept has to be reinforced with hands-on activities. Content scope • Core formulas and functions we rely on every day • Efficient data analysis using pivot tables and related tools Session assets • A clear, well-structured PowerPoint deck that can carry the whole three-hour class • Live demo files and datasets my team can manipulate during each exercise • Step-by-step facilitator notes so the flow is easy to follow and timing stays on target Digital handbook I also want a concise, searchable PDF/OneN...

We are converting a mature, commercially deployed Excel-based financial/audit automation application from VBA to Python. The Excel workbook front-end and custom ribbon stay; all processing logic moves to a Python engine running behind Excel. THE SYSTEM: • ~56,000 lines of VBA across a main workbook and add-ins, developed and patched over 15+ years • Modules include: data import and mapping wizards, journal/adjustment engines, configurable settings panels, analytical calculations, multi-step report generation wizards, sampling tools, and a cash flow statement engine • Full installed environment, source code, and user documentation will be provided under NDA SCOPE OF WORK: 1. PLANNING PHASE: Analyze the VBA codebase and produce a technical planning document — module inv...

I have prepared a design brief (see the ZIP) that shows the look and feel I want: one page for entering a register of referral relationships and their milestone activities, and a second page that turns those entries into a clean, professional-looking dashboard. The workbook needs only straightforward formulas—nothing heavy on macros—but it must calculate totals and status summaries automatically so the overview always reflects the latest input. You will build: • Sheet 1 – a clearly laid-out input form where users can type or paste each referral partner, the date of each milestone, and any notes I have specified in the mock-ups. Data validation and drop-downs should guide users so entries stay consistent. • Sheet 2 – an interactive dashboard that pulls f...

instruction to be applied in excel sheet

Call Center Performance Dashboard in Microsoft Excel Created a professional Microsoft Excel dashboard to monitor call center performance. The workbook includes Break Efficiency Tracking Agent Efficiency Analysis Overall Performance Report Excel formulas and calculations Clean and organized data Performance monitoring and reporting Skills Used: Microsoft Excel, Formulas, Data Analysis, Reporting, Dashboard, Conditional Formatting

I have a sizeable spreadsheet that needs a thorough clean-up in Microsoft Excel. The raw file contains duplicates, inconsistent formats, stray blanks and a few obvious typos. I’m looking for someone who can methodically work through the sheet—using whatever mix of formulas, Power Query, or manual checks you prefer—to deliver a polished, analysis-ready workbook. Accuracy is more important than speed, so the timeline is flexible. When you respond, please highlight your experience handling similar Excel data-cleaning jobs; examples of past successes will help me gauge fit. Final deliverable: the cleaned Excel file plus a short note summarising the main issues you found and the fixes you applied.

I have a collection of digital files that hold nothing but raw lists of names and addresses. I need every single entry moved into a clean Microsoft Excel workbook with absolute accuracy—no spelling slips, transposed numbers, or missing fields. The layout I’m after is straightforward: each component of the address (first name, last name, street, city, state, postcode, and country when supplied) goes into its own column so I can filter and sort later without hassle. I will provide all source files in their current digital format along with a brief field guide that shows how each line should map to the spreadsheet. When you return the finished .xlsx file I’ll spot-check it against the originals, so consistent formatting and 100 % data fidelity are essential. If you use sho...

I’m putting together a three-hour Excel workshop for an Information Technology team of roughly 15–20 people and I need a complete training package that hits both basic and intermediate skills. The focus is on practical ability, so every concept has to be reinforced with hands-on activities. Content scope • Core formulas and functions we rely on every day • Efficient data analysis using pivot tables and related tools Session assets • A clear, well-structured PowerPoint deck that can carry the whole three-hour class • Live demo files and datasets my team can manipulate during each exercise • Step-by-step facilitator notes so the flow is easy to follow and timing stays on target Digital handbook I also want a concise, searchable PDF/OneN...

I have a collection of digital files that hold nothing but raw lists of names and addresses. I need every single entry moved into a clean Microsoft Excel workbook with absolute accuracy—no spelling slips, transposed numbers, or missing fields. The layout I’m after is straightforward: each component of the address (first name, last name, street, city, state, postcode, and country when supplied) goes into its own column so I can filter and sort later without hassle. I will provide all source files in their current digital format along with a brief field guide that shows how each line should map to the spreadsheet. When you return the finished .xlsx file I’ll spot-check it against the originals, so consistent formatting and 100 % data fidelity are essential. If you use sho...

I have a set of Excel workbooks that I consult daily and I’m ready to turn them into a single, interactive Power BI dashboard for my own use. I’ll supply the spreadsheets; you will connect, clean and model the data directly in Power BI, then design a sleek report with custom visuals—not just the default bar or pie charts. What matters most is clarity, speed and flexibility: I need to spot trends at a glance, drill down when something looks off, and update the dashboard easily whenever I drop a new file into the folder. If DAX measures or Power Query transformations are required, go ahead and build them in; just keep the logic readable so I can maintain it later. Deliverables • A .pbix file linked to my Excel sources, fully refreshable • All custom visu...

I want to clean up and speed up the way we handle vendor and customer invoices. Right now the flow touches SAP FI, MM and SD as well as a set of Microsoft Excel workbooks that staff use for preliminary checks. The immediate priorities are: • Accurate data entry and verification at each step, so master data, PO numbers, tax codes and payment terms always match. • Eliminating as many repetitive keystrokes as possible—whether that means SAP scripting, BAPIs, Fiori apps, VBA macros in Excel, or an RPA bot that can move between both platforms seamlessly. You’ll start by mapping the current steps, highlight where errors or double-entry happen, then build and test the automation or validation logic. A concise hand-over guide and annotated code/scripts are part of the...

I have a set of raw sales figures and I need an Excel-based dashboard that surfaces only one KPI—revenue. Charts are not necessary; a clear, dynamic layout that lets me filter, sort, and instantly see total and segmented revenue is what matters. The file should open on a summary page that automatically refreshes from the underlying data table, highlights key numbers with conditional formatting, and offers simple slicers or drop-downs for date ranges and product groups. Everything must run on native Excel features (Power Query or Power Pivot are fine) so I can maintain it without add-ins. Deliverable: a single .xlsx file with all formulas, queries, and named ranges unlocked and cleanly documented so I can follow the logic.

I’m organising an on-site workshop for a group that already works confidently in Excel and wants to take their skills to the next level. The participants handle complex spreadsheets daily, so the content must dive straight into expert territory—no time spent on the basics. Core topics we need covered • Macros & VBA: writing, editing, and debugging code that automates repetitive tasks. • PivotTables & PivotCharts: building multi-layered summaries and interactive dashboards. • Data Analysis & Visualisation: advanced formulas, scenario analysis, and clear graphical storytelling that supports decision-making. What I’m after – A trainer who can run engaging, hands-on sessions at our premises (exact location and dates to be agreed). ...

Saya sedang menyiapkan sebuah kampanye dan membutuhkan bantuan Anda untuk merancang satu poster bergaya minimalis. Fokusnya adalah kesederhanaan yang elegan namun tetap kuat menyampaikan pesan. Lingkup pekerjaan • Konsep visual: saya memberi arahan tema dan teks utama; Anda mengembangkan ide layout dan tipografi yang clean. • Desain final: versi siap cetak (A3, CMYK, 300 dpi) serta versi digital untuk media sosial. • File sumber: Adobe Illustrator atau Photoshop beserta font dan aset pendukung. • Revisi: hingga dua kali penyesuaian ringan jika diperlukan agar hasil benar-benar sesuai harapan. Yang saya cari • Portofolio desain grafis, khususnya contoh poster minimalis. • Ketelitian tinggi, kreativitas, dan komunikasi responsif sepanjang proses. &bu...

My VBA-driven workbook suddenly throws an error on Windows 11 with Office 2019. I need someone who can jump in right away, locate the glitch, and patch it within the next couple of hours. I will send the workbook and a brief note on the steps that trigger the failure. Once you reproduce the problem, please clean up the code, make it robust for this environment, and send the corrected file back along with a short summary of what you changed and why. Deliverables • Repaired Excel file with fully functioning macro • One-paragraph changelog outlining the fix If you are confident with VBA in Office 2019 and can start immediately, this should be an easy win for you and a quick resolution for me.

I need a freelancer to convert a dozen Word and Excel forms into auto-fill formats. These forms are currently used for written reports and invoicing. Requirements: - Convert Word/Excel forms to an auto-fill format. - Maintain the integrity of text input fields, checkboxes, multiple choice fields, and dropdown menus. Ideal Skills and Experience: - Proficiency in Word, Excel, and form automation tools. - Attention to detail to ensure accurate field mapping.

Por favor, regístrate o inicia sesión para ver los detalles.

I’m looking for an Excel-based solution that lets me maintain a fully linked set of financial statements without touching a calculator. The workbook should open to a clean, user-friendly dashboard where I can enter raw transaction data (or paste it in) and instantly see an updated Balance Sheet as well as an Income Statement, Cash-Flow Statement, and Statement of Changes in Equity. Core deliverables • Balance Sheet • Income Statement • Cash-Flow Statement • Equity Statement Key features to build in • Automated calculations that flow through every schedule and roll forward ending balances automatically. • Clear, presentation-ready graphs and charts that refresh with each data update so trends are visible at a glance. • Solid data-va...

I need an interactive Power BI dashboard that pulls its data directly from a set of Excel workbooks I will supply. The core of the job is to connect to those sheets, model the data cleanly, and design compelling visuals that let me slice and drill down without having to touch the underlying files. You are free to suggest the most meaningful charts and KPIs once you see the data, but the refresh must remain one-click simple: whenever I replace the source Excel files, the dashboard should update automatically. If you think an additional source—such as a SQL database or an online service—would improve insights later on, please note it in your proposal; for now everything needs to function with Excel alone. Deliverables: • A fully-functional .pbix file linked to my Excel da...

I’m looking for an Excel-based solution that lets me maintain a fully linked set of financial statements without touching a calculator. The workbook should open to a clean, user-friendly dashboard where I can enter raw transaction data (or paste it in) and instantly see an updated Balance Sheet as well as an Income Statement, Cash-Flow Statement, and Statement of Changes in Equity. Core deliverables • Balance Sheet • Income Statement • Cash-Flow Statement • Equity Statement Key features to build in • Automated calculations that flow through every schedule and roll forward ending balances automatically. • Clear, presentation-ready graphs and charts that refresh with each data update so trends are visible at a glance. • Solid data-va...

I need an Excel spreadsheet fully replicated in Google Sheets. Requirements: - Transfer of all formulas and calculations - Complex functions: VLOOKUP/HLOOKUP, IF/AND/OR, and array formulas - Application of data validation rules and conditional formatting Ideal Skills and Experience: - Proficiency in both Excel and Google Sheets - Experience with complex formulas and data validation - Attention to detail to ensure accuracy in migration

Saya membutuhkan bantuan untuk membuat sebuah tabel yang rapi dan siap pakai untuk keperluan analisis data. Fokus utamanya adalah: • Data yang diolah: Data penjualan dan data pelanggan. • Kolom inti yang harus ada: Tanggal dan Jumlah. Saya ingin hasil akhirnya berupa file spreadsheet (Excel atau Google Sheets) dengan struktur yang mudah difilter, diurutkan, dan kalau perlu langsung dipakai untuk membuat pivot table atau grafik sederhana. Mohon sertakan pengaturan format tanggal yang konsisten dan rumus dasar (misalnya total, rata-rata, atau pertumbuhan sederhana) agar analisis awal bisa langsung dijalankan. Silakan lengkapi dengan kolom bantu lain jika menurut Anda dapat meningkatkan kualitas analisis, tetapi pastikan dua kolom inti di atas tetap menjadi prioritas.

I need a single Excel workbook tailored for our mechanical department that can automatically turn raw operational data into clear summary reports. The main purpose is to generate three report types—Monthly Performance, Maintenance Schedule, and Inventory—without extra manual manipulation, because the engineers who will use it have limited time to tinker with formulas. Here’s what I have in mind: • One ​input sheet where engineers can paste or import daily data. • Backend formulas, pivot tables, or VBA (your call) that clean, sort, and calculate the required metrics. • Three dedicated report tabs—Performance, Maintenance, Inventory—that update instantly once new data is entered. Acceptance criteria • All calculations refresh with a single ...

I’m looking for an Excel-based solution that lets me maintain a fully linked set of financial statements without touching a calculator. The workbook should open to a clean, user-friendly dashboard where I can enter raw transaction data (or paste it in) and instantly see an updated Balance Sheet as well as an Income Statement, Cash-Flow Statement, and Statement of Changes in Equity. Core deliverables • Balance Sheet • Income Statement • Cash-Flow Statement • Equity Statement Key features to build in • Automated calculations that flow through every schedule and roll forward ending balances automatically. • Clear, presentation-ready graphs and charts that refresh with each data update so trends are visible at a glance. • Solid data-va...

You will be working directly in Microsoft Excel to transfer mixed data—both numbers and text—into pre-made sheets that I will share at the start of the project. The layout is already set, so you won’t need to create categories or redesign the workbook; your focus is pure data entry with accuracy front and centre. Every line you enter must pass two quality gates: first, a quick spell-check to catch typos in text fields, and second, a numeric review to be sure figures match the source documents exactly. Feel free to use Excel’s built-in spell checker, simple validation formulas, or any other technique you prefer as long as the final file is error-free. I’ll supply the source material in PDF and Word format, along with a short guide on naming conventions for th...

Rebuilding an unwieldy quoting tool into a clean, modular system is a highly effective way to eliminate errors and speed up your workflow. Keeping reference data separate from your main calculation engine ensures that updating yearly rates won’t break your active client templates. Here is the blueprint for your new, streamlined Excel quotation system. System Architecture To ensure reliability, all four workbooks must be saved in the same local folder or cloud directory. Excel resolves relative paths automatically for files in the same folder, preventing broken links. 1. Primary Workbook: This is the only file your team will open daily. It handles inputs and generates the client-facing quote. • Sheet 1: Cover & Inputs • Fields: Client Name, Project Title, Date...

Por favor, regístrate o inicia sesión para ver los detalles.

I have several Excel workbooks that hold our monthly quality and membership data. I need a single Power BI report that pulls from those files and turns the raw numbers into an at-a-glance dashboard for three focus areas: • Quality Performance – highlight current-month compliance rates and any supporting “gaps and measures” metrics we define together • Gaps & Measures – drill-downs that surface performance gaps so leadership can trace root causes quickly • Member Roster Status – a visual snapshot of which members are active, pending, or inactive this month All visuals should refresh automatically when the underlying Excel files are updated and allow filtering by month, team, and location. Clean, executive-friendly styling is important...

I need an Excel-driven product configurator that pushes parameters to Autodesk Inventor and automatically outputs the corresponding 3D model. The workbook will present a handful of predefined options—basic length, width, height and material selections—so the user can pick values from drop-downs, press a single button, and watch Inventor build the part or assembly in the background. Scope • Create a clean, password-protected Excel interface (xlsm) with clearly labelled input cells and validation lists for each option. • Link those inputs to an Inventor template through VBA, iLogic, or Inventor’s API—whichever is most robust—so the model regenerates instantly and saves to a specified folder. • Include error handling that alerts the user i...

I’m looking for an Excel-based solution that lets me maintain a fully linked set of financial statements without touching a calculator. The workbook should open to a clean, user-friendly dashboard where I can enter raw transaction data (or paste it in) and instantly see an updated Balance Sheet as well as an Income Statement, Cash-Flow Statement, and Statement of Changes in Equity. Core deliverables • Balance Sheet • Income Statement • Cash-Flow Statement • Equity Statement Key features to build in • Automated calculations that flow through every schedule and roll forward ending balances automatically. • Clear, presentation-ready graphs and charts that refresh with each data update so trends are visible at a glance. • Solid data-va...

I want to turn a plain-looking workbook into a polished fintech experience, completely inside Excel. The end result should feel like commercial software rather than a template, with clean navigation, protective formatting and responsive formulas/VBA so users never see the “spreadsheet guts.” Design tone I gravitate toward a classic aesthetic—elegant typography, restrained colour palette, clear hierarchy—so every sheet and chart needs to reflect that timeless look. Phase-one focus We will begin with the Income Tracker. I need an input interface that feels form-based, instantly categorises income streams, and rolls the data into dynamic views (daily, weekly, monthly). Slicers or a custom ribbon button for quick period changes are welcome if they keep the expe...

I have several digital files—specifically Excel sheets—containing pure text data that must be transferred into a consolidated workbook. The job is simple in concept yet detail-heavy in practice: every cell needs to match the source exactly, with spelling, spacing, and capitalization preserved. You will receive the Excel files, along with a template of the final master sheet. Your task is to copy or re-type the text into the corresponding columns, check for duplicates, and keep the overall structure intact. A quick turnaround is appreciated, but accuracy is non-negotiable; one misplaced character skews our internal searches and reports. Once finished, send back the updated master workbook and a brief note confirming the total number of rows you entered so I can cross-check...

I need a clean, ready-to-use Excel file that lets me organise mobile numbers for my business contacts. I will be recording each contact’s name, company, designation, primary mobile number and a few optional fields such as email, city and short notes. The sheet must be simple for day-to-day data entry yet professional enough to filter, sort or search quickly when the list grows. Practical touches like data-validation on the mobile column (to ensure only 10-digit numbers), drop-downs for city or category, and conditional formatting for duplicates will help a lot. I’d also like a summary tab that instantly shows the total number of contacts and highlights any missing key details. Deliverable: one Excel workbook (.xlsx) that opens without macros on Microsoft 365, already formatte...

I have fewer than 1,000 rows of financial figures that must be transferred accurately into an Excel workbook. The source material consists of PDF statements and CSV exports, and each record includes date, account, description, debit, credit, and running balance. Your primary responsibility is precise data entry—values must reconcile perfectly with the originals and preserve their number formatting for later analysis. If you’re comfortable adding simple checks (SUM totals, running balances, or conditional-formatting flags for outliers) please let me know; it will speed up my own review once the file is complete. Deliverable • A clean, fully-populated Excel file (.xlsx) containing every record from the source documents, ready for any follow-on tasks such as cleaning,...

I have several batches of customer information that must be transferred into Excel with precision and kept up-to-date. Your core tasks will be simple but detail-oriented: copy the raw data I supply, arrange it in a clean standard table layout, apply the dropdown lists I specify for key fields (so typos never creep in), and return the file on the agreed schedule. Because these are real customer records, consistency and confidentiality matter just as much as speed. I’ll share a template showing the exact column order; you’ll populate the sheet, double-check for missing entries, and keep the file tidy so I can filter or run quick summaries later. Deliverables • One fully populated Excel workbook per batch, using my standard table format • Dropdown validations in ...

I want to give our in-house Microsoft Access application a cleaner, more intuitive interface without touching its underlying tables, queries, or core VBA logic. The test assignment will be a single form; once that looks and feels right we will apply the same treatment to the rest of the system. What needs attention • General layout—better alignment, comfortable spacing and padding, and clearer grouping of related fields. • Navigation—smarter use of tabs so users reach the data they need in fewer clicks. • Visual polish—modern button styles with meaningful icons, consistent font types and sizes, and a cohesive color scheme that reinforces hierarchy and readability. I will supply the current .accdb, a style guide of our corporate colors, and notes on ...

I keep a growing set of records in Excel and I want to stop typing everything straight into cells. Instead, I need a small automation tool—built directly inside the workbook—that pops up a clean, user-friendly form, lets me key in each new record, and then stores the information in the correct table automatically. Core needs • Form-based data entry only; no direct cell editing. • Data are entered manually, so the form should guide the user with drop-downs, date pickers, and basic validation to prevent typos or blanks. • Once a record is submitted, the macro should place it in the next empty row of the master sheet and, if possible, time-stamp the entry. • A simple “Edit existing record” function would be a bonus but is not essential fo...

I’m looking for an Excel-based solution that lets me maintain a fully linked set of financial statements without touching a calculator. The workbook should open to a clean, user-friendly dashboard where I can enter raw transaction data (or paste it in) and instantly see an updated Balance Sheet as well as an Income Statement, Cash-Flow Statement, and Statement of Changes in Equity. Core deliverables • Balance Sheet • Income Statement • Cash-Flow Statement • Equity Statement Key features to build in • Automated calculations that flow through every schedule and roll forward ending balances automatically. • Clear, presentation-ready graphs and charts that refresh with each data update so trends are visible at a glance. • Solid data-va...

Based on everything we’ve worked through, you’re not just building a dashboard—you’re building a workforce planning platform. A freelancer will do much better if they understand the business problem first. ⸻ Workforce Planning & Labor Intelligence Dashboard Project Overview I am creating an Excel-based workforce planning and labor intelligence tool for a large distribution center. The goal is to replace manual staffing decisions with a centralized, data-driven system that helps leaders make faster and more accurate labor decisions. The dashboard will combine information from multiple Excel sheets into one interactive workbook that automatically calculates staffing health, labor gaps, attendance, and workforce recommendations. This tool is designed for thre...

I’m looking for an Excel-based solution that lets me maintain a fully linked set of financial statements without touching a calculator. The workbook should open to a clean, user-friendly dashboard where I can enter raw transaction data (or paste it in) and instantly see an updated Balance Sheet as well as an Income Statement, Cash-Flow Statement, and Statement of Changes in Equity. Core deliverables • Balance Sheet • Income Statement • Cash-Flow Statement • Equity Statement Key features to build in • Automated calculations that flow through every schedule and roll forward ending balances automatically. • Clear, presentation-ready graphs and charts that refresh with each data update so trends are visible at a glance. • Solid data-va...

SwiftUI Swift Concurrency (async/await & Actors) Combine Clean Architecture MVVM-C Dependency Injection SOLID Principles Memory Management CI/CD Senior-level iOS best practices

SwiftUI Swift Concurrency (async/await & Actors) Combine Clean Architecture MVVM-C Dependency Injection SOLID Principles Memory Management CI/CD Senior-level iOS best practices

I need a single, easy-to-use Excel workbook dedicated to data entry for customer information. The goal is to let anyone on my team open the file and start typing without worrying about layout or errors. Here’s what I’m after: • An input area (form or clearly marked table) that captures all the customer fields I’ll supply once we start. • Custom formatting throughout—title-case names, phone numbers masked as (000) 000-0000, emails forced to lowercase, dates shown as dd-mmm-yyyy, and any other rules we agree on. • Data-validation dropdowns for categorical fields such as region or customer status. • Conditional formatting that flags missing mandatory cells or obvious entry mistakes. • Protected formula or helper columns where usefu...