Minitab vba jobs
...dashboard that turns those raw rows into insight. The layout should feature bar charts, pie charts, and line graphs so supervisors can see at a glance where we stand. Key metrics are straightforward—total production volume and accumulated downtime—updated automatically each day as fresh data is entered. The solution must sit entirely inside Excel (Power Query, PivotTables, dynamic arrays, or light VBA—use whichever combination keeps the file fast and maintenance-friendly). A single click refresh is plenty; real-time streaming is not required. Deliverables • One dashboard tab with the visualisations laid out cleanly for shop-floor display • Any supporting queries, tables, or macros, clearly organised and named • Brief “how-to” not...
I have an existing Excel VBA workbook that is already developed and mostly working fine. However, sometimes it hangs or becomes slow when using buttons in the first sheet. I need a freelancer to review the existing VBA code, fix the issue, and improve the file’s performance and stability without changing the current working logic. This is mainly a small debugging and optimization task, not a full development project.
...address • Email and phone number Once the data is validated and entered, I want every row assigned to a clear category column that identifies the customer type, so the final sheet can be quickly filtered or reported on. Simple Excel formulas such as CONCAT, TRIM, and basic IF statements should be used where they save time and improve consistency; however, there is no need for advanced macros or VBA. Accuracy is critical—I will be cross-checking a sample of the finished data before sign-off—so please double-check spellings, spacing, and the integrity of any formulas you add. I’ll provide the raw file, a short key that explains each customer type, and an example of the desired layout. The completed workbook should be returned ready for immediate use, wi...
...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 sh...
I need a streamlined VBA-driven workflow in Excel that lets me handle all incoming payroll data quickly and error-free, then produce a clean summary at the click of a button. The workbook must support three core activities: 1. Data entry – A simple userform for typing in one-off adjustments or new employee lines. 2. Data importing – A macro that pulls in weekly CSV exports from our time-clock system, places them in the right tables, and maps every column automatically. 3. Data validation – Rules that flag duplicate employee IDs, detect missing dates or rates, and stop bad records before they pollute the file. Once the data is in place and passes validation, I want a single “Generate Summary” control that produces an easy-to-read payroll summary...
I already have a working Excel workbook in daily use, but its current macros are slow, brittle, and hard to maintain. I need an experienced VBA developer to dive into the existing code, streamline the logic, and add any missing functionality so routine tasks run reliably at the click of a button. Although the immediate scope is limited to Excel, I would like the code written cleanly enough that it could later be adapted for Access or Word–based reporting if the project grows. After an initial review of the file, we can agree on the exact touch-points, but my priorities are: • Refactor or replace outdated VBA modules • Optimise speed and eliminate manual steps wherever possible • Add clear in-line comments and a brief user guide sheet • Leave ...
...sale, purchase, expense and bank movement each week and roll them into simple monthly management statements I can read at a glance. • GST Compliance – Keep my input-credit registers tidy, draft and file the regular GST returns on time, and store the acknowledgements neatly with the working files. • Advanced Excel – Build or refine spreadsheets with pivot tables, lookups, Power Query or light VBA so recurring reconciliations and variance analyses run at the click of a button. • MS Office Reporting – Package the numbers into a short Word or PowerPoint summary when I need to brief other stakeholders. Deliverables must reconcile to bank statements with zero variance, trigger no validation errors on the GST portal, and arrive in fully edita...
I have three Excel workbooks whose VBA-driven macros used to handle a handful of quick calculations and automated steps for my students. Those functions have stopped running altogether—no errors, just macros that refuse to fire—so first I need the existing code reviewed, debugged, and restored to full working order. Once everything works flawlessly in Excel, the same functionality has to live inside Google Sheets. After you tidy up the VBA, please translate it into clean, well-commented Google Apps Script, embed it in a Sheets copy of each file, and make sure the buttons or menu items behave exactly as they do on the desktop. Deliverables • Repaired VBA across the three original worksheets • Change log or in-line comments explaining what you f...
...sale, purchase, expense and bank movement each week and roll them into simple monthly management statements I can read at a glance. • GST Compliance – Keep my input-credit registers tidy, draft and file the regular GST returns on time, and store the acknowledgements neatly with the working files. • Advanced Excel – Build or refine spreadsheets with pivot tables, lookups, Power Query or light VBA so recurring reconciliations and variance analyses run at the click of a button. • MS Office Reporting – Package the numbers into a short Word or PowerPoint summary when I need to brief other stakeholders. Deliverables must reconcile to bank statements with zero variance, trigger no validation errors on the GST portal, and arrive in fully edita...
I need VBA script to execute stored procedure that I have in oracle SQL with some parameter input from excel
...compares actuals vs. plan and flags variances automatically. • Valuation outputs—DCF, multiples, and scenario-sensitive sensitivity tables—presented in a concise summary tab that I can drop straight into a pitch deck. • Clear, commented formulas in Excel (or Google Sheets) so future edits are painless, plus a brief walkthrough video or PDF that explains the logic. If you prefer Power Query, VBA, or even a lightweight Python script to automate data pulls, feel free to suggest it—efficiency matters as long as the final deliverable remains easy for non-technical stakeholders to use. Acceptance criteria: numbers reconcile down to the last cent; sensitivities recalculate without error; and every assumption is both traceable and editable in one place. ...
...sale, purchase, expense and bank movement each week and roll them into simple monthly management statements I can read at a glance. • GST Compliance – Keep my input-credit registers tidy, draft and file the regular GST returns on time, and store the acknowledgements neatly with the working files. • Advanced Excel – Build or refine spreadsheets with pivot tables, lookups, Power Query or light VBA so recurring reconciliations and variance analyses run at the click of a button. • MS Office Reporting – Package the numbers into a short Word or PowerPoint summary when I need to brief other stakeholders. Deliverables must reconcile to bank statements with zero variance, trigger no validation errors on the GST portal, and arrive in fully edita...
...sale, purchase, expense and bank movement each week and roll them into simple monthly management statements I can read at a glance. • GST Compliance – Keep my input-credit registers tidy, draft and file the regular GST returns on time, and store the acknowledgements neatly with the working files. • Advanced Excel – Build or refine spreadsheets with pivot tables, lookups, Power Query or light VBA so recurring reconciliations and variance analyses run at the click of a button. • MS Office Reporting – Package the numbers into a short Word or PowerPoint summary when I need to brief other stakeholders. Deliverables must reconcile to bank statements with zero variance, trigger no validation errors on the GST portal, and arrive in fully edita...
...of mixed text and numeric fields. My aim is to identify and flag records that are not exact duplicates but close enough to be considered the same customer, product, or transaction. In other words, I need a reliable fuzzy-matching solution that surfaces these near-matches so I can review and consolidate them. Here is what I need from you: • A working Excel-based approach—formulas, Power Query, VBA, or a combination—that compares the mixed fields and returns a similarity score or direct match flag. • Clear, editable logic so I can tweak thresholds or add new columns later without rewriting the whole thing. • A brief walkthrough (written notes or short screen capture) showing how the matching was set up and how I can re-run it when new data arrives. ...
I have several Excel workbooks of 150,000 + rows containing names, job titles and email addresses. I need a VBA macro that can comb through the Job Title column, spot rows whose titles match a set of keywords that I will provide, copy those rows (or just the email addresses—your guidance is welcome) into a brand-new worksheet, and leave the source data untouched. Key requirements • Source files are always in native Excel format, so you can rely on worksheets, ranges and tables rather than import code. • The solution must handle both a one-click manual run (e.g., a ribbon button) and an automatic mode that fires when a file is opened or dropped into a folder. • Performance matters: even on 150k rows the scan and copy should feel snappy, so efficient loopin...
I keep all of my renewal data in a single Excel workbook, and every time I need to review information for a specific customer I have to re-apply filters manually. I want that entire routine collapsed into a single click. Here’s what I need: a lightweight automation—VBA, Power Query, or another native Excel approach—that sits inside the file and instantly filters the renewal dataset by customer whenever I press a button or choose a custom ribbon command. The solution must work in standard desktop Excel (Microsoft 365), recognise new rows automatically as the table grows, and preserve any existing formulas and pivot tables. Please deliver a working, macro-enabled version of the workbook (or a clearly commented code module I can import) along with a short set of ins...
I have a set of raw survey results that I need prepared for deeper analysis. The core task is data cleaning inside Excel: removing duplicates, handling blank or inconsistent entries, normalizing date or rating f...or rating formats, and making sure every column is analysis-ready. Once the file is cleaned I should be able to drop it straight into pivot tables or statistical add-ins without further fixes. Please keep all original fields intact, add a clearly labeled “Cleaned” worksheet, and document any transformation rules you apply in a small notes tab so I can audit or tweak them later. If you have VBA routines, Power Query tricks, or other proven Excel techniques that speed up repeat cleaning, feel free to use them—the deliverable just needs to stay within ...
I need a clean, well-structured Excel file that will hold and organise my financial data. The workbook should be laid out so new entries flow in exactly where they belong and key numbers update automatically. On top of that, I want each re...into the Excel workbook (or a synced Google Sheet that feeds the workbook). • With one click, a macro or script places the chosen record into a pre-formatted Word file—totals, dates, notes and all—ready for download or email. The final deliverable is the finished spreadsheet, the Google Form–to-Excel link, and the automated Word export function. It should run smoothly on current Microsoft 365; VBA or Power Query is fine as long as it’s reliable. Clear instructions on how to add new fields in the future would be th...
I need an Excel automation expert to set up a system that filters data based on specific text criteria and copies it to a new workbook. The filtering and copying should be triggered by a button click....up a system that filters data based on specific text criteria and copies it to a new workbook. The filtering and copying should be triggered by a button click. Key Requirements: - Apply text filters to Excel data - Automatically filter and copy data to a new workbook - Action triggered by a button click Ideal Skills and Experience: - Proficiency in Excel, especially with automation tools like VBA - Experience with setting up button-triggered actions in Excel - Attention to detail and accuracy in data handling Looking for a freelancer who can deliver a clean, functional solution ef...
I’d like a streamlined Excel tool that lets me generate instant cost estimates for flyer jobs in my printing press. The sheet should prompt me for key variables—paper type, quantity, print quality, freight...Behind-the-scenes formulas that add mark-ups, combine fixed and variable costs, and flag any negative margins • An easy-to-read summary section showing subtotal, tax (if I toggle it on), and final figure If you can add optional dropdowns for common paper stocks and a printable quotation sheet, that’s a plus. Please send a detailed project proposal explaining your layout concept, key formulas or VBA snippets you’d use, and an example of a similar cost calculator you’ve built. I’m ready to choose quickly once I see a plan that keeps d...
I need an Excel feature that adds a "+" button to duplicate both rows and columns of a sheet. The duplicated parts should maintain their original formulas and values. Requirements: - Excel proficiency - Experience with VBA or Excel macros for customization
...our online database and instantly return both customer and project details. When a match is found, the form should auto-populate the relevant cells; when no match exists, every field must remain editable so I can type the information in myself from scratch. The workbook is already on OneDrive, so please design the solution to run smoothly there, whether you choose built-in Excel Forms, a bit of VBA, Power Query, or a lightweight Office Script—whichever you feel is most reliable for cloud use. Key fields will include project ID, customer name, address, phone, project description, and status. All lookups reference our SQL-based database via its standard connection string, which I will provide. Deliverables • A working form embedded in the same workbook • Conne...
I need an Excel workbook that lets me record everything that happens in the shop each day and then spits out a clean date-stamped PDF summary at the click of a button. For the sales section I will type the user name, the sale amount and whether it was Cash or Credit; the sheet should total both ...calculate daily totals for cash sales, credit sales, expenses and credit payments • show the net cash position for the day (cash sales + credit payments – expenses) • let me pick the report date from a drop-down or calendar and then generate a neatly formatted PDF summary after I press a “Create Report” button Please build this with standard Excel functions and, if needed, a small, well-commented VBA macro to handle the PDF export so it works on any recent...
...Expected Processing Logic (Power Query) The solution should: • Use Power Query to ingest all source Excel files from a shared OneDrive folder • Clean, standardize, and validate data (dates, truck numbers, depot names) • Link datasets using: o BL Number o Truck Number o Trip / Load ID o Customer / Order reference • Produce clean fact and dimension tables suitable for later migration to Power BI • Avoid VBA and Excel-only logic All transformation logic should be documented and reusable. 4. Dashboards & Outputs 4.1 BL & Hospitality Overview • Active BL list Hospitality expiry countdown • Volume lifted vs remaining per BL • Vessel and consignee visibility 4.2 Fleet Journey Status (Long Haul) • Truck count by journey segment: o Dar...
...the raw figures in the cells. Key points you should know • Update trigger: only when a new URL is pasted or an existing one is edited. No recurring cron jobs needed. • Invalid URLs: if the link is broken or not an Instagram post/Reel, the cell should immediately display a clear error message so I spot issues at a glance. • Environment: I am flexible—Google Sheets (Apps Script), Excel with VBA, or a lightweight Python script that writes back into the sheet through an add-in or API would all work. Use the method you are most confident will stay stable with Instagram’s current endpoints. • Rate limits & log-ins: please handle any authentication or token requirements internally so I only need to paste the link and see the numbers. Deliver...
...in a OneDrive-hosted workbook. In my main reporting file I want a table that refreshes automatically, pulls in only the rows whose transaction dates fall between two cells (StartDate and EndDate in the report), collapses duplicate product lines into a single row, and adds their quantities together. Please build this entirely in Microsoft Excel. Power Query seems the natural choice, but a clean VBA routine is fine if it meets the same “one-click / on-open” refresh behaviour and continues to work when the file is synced through OneDrive. Core expectations • The path to the external workbook must stay dynamic so it continues to resolve once OneDrive assigns it a cloud URL. • Changing either of the date-range cells must be enough to make the summary re...
I need a experienced Sage 300 developer to help me modify a couple of VBA macros, and to modify the logic on a customised application. These are small projects to be used as a testing ground for larger projects should the results and working relationship be successful.
My multi-sheet inventory workbook has stopped behaving: data no longer cascades from the entry tabs to the summary pages, several formulas now throw #REF! and #VALUE! errors, and the stock-on-hand totals are clearly off. I need the entire calculation flow traced, the break points isolated, and every formula rebuilt so that ne...reorder levels, and valuation figures update automatically the moment data is entered • No #REF!, #VALUE!, or circular reference warnings remain • All named ranges and tables are correctly scoped and documented in a “Changes” tab for future maintenance Excel’s native functions should do the heavy lifting, but feel free to streamline with structured references, dynamic arrays, or lightweight VBA if it keeps the file fast and tr...
I have a small Microsoft Access table of prices—roughly 250 records—that I want turned into a streamlined quoting tool for our sales team. From a single, well-designed form...clean look the customer sees on the final document. Acceptance criteria • Search returns correct record(s) instantly by item name or part number • Quantities multiply against unit prices accurately; totals calculate without rounding errors • One-click export to .docx and .pdf with all branding elements in place • Editable notes field saved inside each quote file • Source file (Access, VBA, or chosen tech) and any supporting scripts delivered, fully documented Once finished the tool will let every salesperson generate and email standardized quotations instead of p...
...sale, purchase, expense and bank movement each week and roll them into simple monthly management statements I can read at a glance. • GST Compliance – Keep my input-credit registers tidy, draft and file the regular GST returns on time, and store the acknowledgements neatly with the working files. • Advanced Excel – Build or refine spreadsheets with pivot tables, lookups, Power Query or light VBA so recurring reconciliations and variance analyses run at the click of a button. • MS Office Reporting – Package the numbers into a short Word or PowerPoint summary when I need to brief other stakeholders. Deliverables must reconcile to bank statements with zero variance, trigger no validation errors on the GST portal, and arrive in fully edita...
...Operating expenses Personnel Automatically flows into: Revenue projections Expense schedules Capex & debt schedules Depreciation Integrated financial statements Dashboard outputs The model must be intuitive for non-Excel-expert partners. Core Requirements 1. Architecture Clear separation of Inputs, Calculations, and Outputs Structured tables (no fragile row references) No unnecessary VBA No hardcoded cross-sheet values Clean sign conventions Scalable timeline 2. Financing Logic Dropdown-driven financing classification: Rent to Own / Operating Lease → Operating Expense Capital Lease / Purchase → Capex + Debt + Depreciation Must automatically flow through the model. 3. Financial Statements Fully integrated: Income Statement Cash Flow Statement...
Gemini said To get the best results from a freelancer (on sites like Upwork or Freelancer.com), you need to be very specific about the "Many-to-Many" issue you mentioned. Here is a clear, ...Deliverables: Input Sheets: Two formatted tables (one for PO, one for GRN) where I can paste new data daily. Summary Dashboard: A Pivot Table or Power BI-style view in Excel showing a summary per Voucher No. Detailed Report: A line-by-line comparison showing exactly which items or taxes don't match. Technology: I prefer a solution using Power Query (to handle the many-to-many relationship) or VBA/Macros for a one-click refresh. Ideal Freelancer: Expert in Excel Power Query and Data Modeling. Experience in Accounting or Supply Chain reconciliation. Ability to create a clean,...
...require thorough data entry focused on cleaning and validation. Every figure must be double-checked for accuracy, inconsistent formats need standardising, and any duplicate or obviously erroneous records have to be flagged and fixed. You will be working directly in the existing Excel files, using whatever techniques you find most efficient—formulas, filters, conditional formatting, even light VBA if that speeds things up—as long as the final sheets remain fully functional and easy for me to audit. Deliverables • A clean, validated version of each original spreadsheet, preserving all columns and row order • A brief log (can be a separate tab) noting the corrections made, the rules you applied, and any outliers that still need my review Acceptance c...
...long-standing Excel workbook (now running in Excel 2019) contains a VBA routine that has reliably processed then pushed both Excel and PDF reports up to our FTP directory for the past nine years. Last month the upload stopped working. It now tries to upload a file to FTP but the file size it is zero. There are a couple of options I can run, one uploads 2 files, the other can do lots more but when I run it only 1 files tries and again the file size is zero; nothing in the FTP server settings has changed, and credentials still test fine through FileZilla, so the issue appears to be inside the spreadsheet or its supporting script. I did change a few items on the spread sheet but I thought I had changed them back. I need you to dive into the VBA, diagnose why the macro no lon...
I need an Excel-based dashboard, driven by VBA, that runs entirely offline and guides pharmacists and clinicians through chronic kidney disease and cardiovascular risk screening. The workbook must accept three kinds of patient inputs: demographics with medical history, current lab tests and vital signs, plus any active medications or treatment plans. As soon as the user enters or pastes that information, the tool should automatically calculate evidence-based risk scores, assign the correct CKD stage, and display clear on-screen prompts for next clinical steps—no internet look-ups, external add-ins, or cloud calls allowed. Fast, intuitive navigation is essential because the primary users will be frontline pharmacists and clinicians working in low-resource settings. I’m e...
...sale, purchase, expense and bank movement each week and roll them into simple monthly management statements I can read at a glance. • GST Compliance – Keep my input-credit registers tidy, draft and file the regular GST returns on time, and store the acknowledgements neatly with the working files. • Advanced Excel – Build or refine spreadsheets with pivot tables, lookups, Power Query or light VBA so recurring reconciliations and variance analyses run at the click of a button. • MS Office Reporting – Package the numbers into a short Word or PowerPoint summary when I need to brief other stakeholders. Deliverables must reconcile to bank statements with zero variance, trigger no validation errors on the GST portal, and arrive in fully edita...
...motorcycle as unavailable for overlapping dates. • Store every reservation in a permanent log that I can filter by bike, customer name, or date range, so I can review usage patterns or settle disputes later. A clean front end (forms, drop-downs, or slicers) is important because different staff members will be using it each day. Behind the scenes you’re free to rely on formulas, tables, Power Query, or VBA—whatever delivers quick automatic availability updates and a reliable, searchable booking history without corrupting the data. Acceptance criteria – Adding or editing a reservation instantly refreshes availability for all motorcycles. – The booking history keeps an untouchable audit trail; deleted or overwritten entries are impossible. &nda...
I’d like an Excel-based workbook that lets me log sales and expenses for my retail operation and instantly see my profit or loss. The file should do more than just total columns—I need meaningful sales an...best-selling items, daily/weekly revenue, and margins. • Built-in expense categorization so I can filter or pivot by cost type. • All formulas locked from accidental edits, with a brief “how-to” tab explaining where to input data and how to refresh reports. I’m fine with standard Excel functions, Power Query or light VBA—as long as everything runs inside a single workbook and works on current Microsoft 365. Please deliver the finished .xlsx (plus macro-enabled version if VBA is used) populated with a small set of sample da...
...storage—or a stand-alone battery bank—makes financial sense for a client. The template must stay friendly for non-technical users: a single “Inputs” sheet where they enter only the basics (system size, quoted purchase price, expected annual production or throughput, tariff information, and a couple of simple assumptions). Behind the scenes the file should run the heavy lifting with clear formulas or VBA, but the visible experience remains tidy and intuitive. Key financial drivers we must cover are up-front investment cost and the ongoing value of energy saved or shifted. Maintenance can sit outside the scope for now; if you prefer to leave a placeholder column that’s fine, but it should not confuse the end user. Because general clients will be read...
...alerts—colour-coded and, ideally, a pop-up or email trigger when a threshold is crossed • Detailed summaries: current balance by size/BF/GSM, monthly usage, ageing stock, and a concise “Order Now” list I will be entering data manually, so friendly forms or dropdown menus for size, BF and GSM will help prevent typing errors. Behind the scenes you can rely on dynamic tables, Power Query, pivot charts, or VBA—whatever produces a fast, maintenance-light file. Acceptance criteria: 1. Dashboard sheet instantly reflects any new inflow or outflow. 2. Reorder triggers and thresholds are easy for me to change. 3. All calculations are protected from accidental edits yet stay transparent for future tweaks. Once tested on a week’s worth of my act...
...ideally their email addresses—sit in a single Excel sheet, and I want those columns to feed straight into the template in one sweep rather than by hand. The plan is to use that imported list, replace the placeholders, save every personalised certificate as <Name>, and fire off an email with the PDF attached—100+ times in just a few minutes, completely error-free. Any approach is fine—VBA mail-merge, Power Automate, a Python script, even Google Workspace—so long as: • the entire run can start with a single click on my Windows 11 / Office 365 machine • every PDF carries only the right learner’s name and date • the PDFs reach the correct inbox with a short, editable email body Deliverables 1. The finished automation (macr...
...sale, purchase, expense and bank movement each week and roll them into simple monthly management statements I can read at a glance. • GST Compliance – Keep my input-credit registers tidy, draft and file the regular GST returns on time, and store the acknowledgements neatly with the working files. • Advanced Excel – Build or refine spreadsheets with pivot tables, lookups, Power Query or light VBA so recurring reconciliations and variance analyses run at the click of a button. • MS Office Reporting – Package the numbers into a short Word or PowerPoint summary when I need to brief other stakeholders. Deliverables must reconcile to bank statements with zero variance, trigger no validation errors on the GST portal, and arrive in fully edita...
I want to streamline a repetitive drafting workflow by building a small suite of Python- and VBA-driven utilities that talk directly to our AutoCAD drawings. My first and most urgent need is an extractor that can open a folder full of DWG files, locate every tag ID drawn inside a rectangle, and return the raw data and accompanying metadata—plus the exact X,Y coordinates of every tag—into a clean Excel workbook. Once the core extractor is working, I also need the same script (or a companion VBA macro) to carry out a few housekeeping tasks automatically: • run validation passes that flag duplicates, impossible formats, or tags that are missing coordinates, • assign an unambiguous primary key so nothing clashes when we merge files later, • sepa...
I need Excel macros to automate data formatting tasks. Essential Tasks: - Primarily focus on automating repetitive tasks to save time. - Key area of automation is data formatting. Ideal Skills and Experience: - Proficiency in Excel and VBA - Experience in creating macros for task automation - Strong understanding of data formatting techniques - Ability to deliver clean, well-documented code Please provide examples of similar work done.
Project Title: Backtest Nifty 50 1-Hour Triple Supertrend Strategy with Options Execution Simulation Objective: I want a complete backtest of my positional strategy on Nifty 50 futures/options to evaluate performance, risk, and viability. The outpu...strategy performs well When the strategy performs poorly Deliverables in Excel or CSV format for all trades and metrics Include all calculations with clear column labels 5️⃣ Communication & Timeline Delivery Time: 7–10 days (negotiable) Regular updates are appreciated Freelancer should clarify doubts about entry/exit rules before starting 6️⃣ Skills Required Python / TradingView / Amibroker / Excel VBA Nifty 50 futures and options understanding Experience in backtesting technical strategies Ability to deliver clean, actionab...
...has to pull data directly from that source – no manual imports. Once connected, I’d like to slice and drill down into campaign performance, spot trends, and compare time periods at a glance. Here’s what matters to me: the layout must be clean and intuitive, KPIs should auto-refresh with one click, and underlying queries need to remain editable so I can tweak them later. If you prefer Power Query, VBA, or another Excel-native method to establish the link, that’s fine as long as it stays within the standard Office environment (no third-party add-ins). Deliverables • A single .xlsx file with a built-in connection to the database • Dynamic charts, slicers, and summary tables ready for daily use • A short set-up note showing where to adju...
...basic styling (date columns as dates, numbers as numbers, text wrapped where needed). Also send me the process and files so that I can test. Key points • 100 % coverage of all result pages on the site, not just a sample. • Output must be an Excel file with the cells pre-formatted for easy sorting and filtering. • Any scraping code or automation tool you build (Python + Selenium/BeautifulSoup, VBA, etc.) should be included so I can rerun the extraction when fresh results are posted. • If the site uses captchas, pagination or dynamic loading, handle those gracefully. • Keep the process compliant with the website’s terms of use. Deliverables 1. The completed, clean Excel workbook. 2. The runnable script or detailed steps you used. On...
...imports, refresh itself with one click, and immediately surface current sales, on-hand inventory, reorder points, and overall profitability. Visual clarity matters: colour coding that highlights exceptions, slicers for quick date or product filtering, and clean charts that resize well on most laptop screens. Feel free to build with PivotTables, Power Query, Power Pivot, dynamic arrays, or concise VBA—whatever delivers speed without bloating the file size. Please structure the workbook so that: • A hidden or clearly separated “Data” area holds raw inputs. • A protected “Dashboard” sheet displays the KPIs and charts only. • Key figures update automatically when new data are loaded. Deliverables • Finished .xlsx (and .xlsm...
...input values are changed. ### Scope * Create a working Excel chart solution using standard Excel functionality * Support a typical monthly dataset (Jan–Dec), but the setup should be easy to reuse * Ensure the color split follows the zero line dynamically (including transitions across zero) ### Technical preferences * **Formula-based solution preferred** (with helper columns/series if needed) * VBA/macros only if necessary (please explain why) * Clean structure so the file is easy to maintain and reuse ### Deliverables 1. Final Excel file (.xlsx) with chart fully configured 2. Short documentation (sheet note or comments) explaining: * where to enter/update data * how the chart works (at a high level) * how to reuse the template for another dataset ### Please...
