
Fechado
Publicado
Pago na entrega
In this homework, you will build a Decision Support System in Microsoft Excel that helps a company allocate its marketing budget across multiple marketing channels. The system will integrate: ● Excel Solver ● VBA macros ● Dashboard visualization The goal of the tool is to determine how much budget should be allocated to each marketing channel to maximize total profit. You will work with the workbook MarketingBudgetTool.xlsm. This project centres on building a VBA-powered Excel workbook that lets me carry out focused data analysis and reporting on my marketing budgets. The file should accept raw spend and performance numbers, run the required calculations at the click of a button, and return clear summaries that guide day-to-day budget decisions. Core requirements • Entire workflow driven by VBA so every refresh, calculation, pivot creation and chart update is fully automated. • Flexible input sheets: I should be able to paste new monthly data without breaking formulas or code. • Dynamic outputs: summary tables, charts and printable pages that highlight budget allocation, variances and ROI at a glance. • Clean, documented code with named modules and comments so I can maintain it in-house later. Acceptance criteria 1. One macro-enabled workbook (.xlsm) delivered, ready to run on Office 365. 2. Input, processing and output areas clearly separated and protected where appropriate. 3. A short video or step-by-step PDF showing how to refresh data, add new months and customise report parameters. Include any helpful techniques—advanced formulas, Power Query calls, or ActiveX controls—provided they run smoothly inside Excel with no external add-ins.
ID do Projeto: 40311837
18 propostas
Projeto remoto
Ativo há 21 dias
Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
18 freelancers estão ofertando em média $29 USD for esse trabalho

I can build a VBA-powered Excel Decision Support System using Solver to optimize marketing budget allocation, with one-click automation for calculations, pivots, and dashboards. The workbook will feature flexible inputs, dynamic ROI summaries, and fully documented code, delivered as a ready-to-use .xlsm with a short guide. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$20 USD em 1 dia
6,5
6,5

Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Power Query, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • VBA & Macros • Data Analysis • Anova analysis in Excel • Statistic & Modeling using Excel • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Sneh
$50 USD em 1 dia
6,2
6,2

Hello, I can create a fully automated VBA-powered Excel workbook (.xlsm) for your marketing budget allocation, integrating Solver, dynamic dashboards, and clear reporting. The tool will allow you to paste new data easily, run calculations and optimizations with one click, and generate summary tables, charts, and ROI analysis automatically. I’ll provide clean, documented code, separate input/output areas, and a short PDF guide showing how to refresh data, add months, and customize reports—all ready to use in Office 365 without external add-ins. Regards, Zafar
$30 USD em 1 dia
6,2
6,2

With over a decade of professional experience in advanced Excel solutions and VBA automation, I'm confident I can effectively deliver on your marketing budgeting tool project. My proficiency in data analysis, processing, and management will ensure the entire workflow of the workbook is driven by VBA, creating a seamless and fully automated experience for you. My ability to create flexible input sheets will allow you to easily paste new monthly data without breaking any formulas or code. Furthermore, I understand how important dynamic outputs are for comprehensive analysis and reporting. I'll design summary tables, charts and printables that not only provide valuable insights into budget allocation but also highlight variances and ROI at a glance. I’m committed to delivering an intuitive system that even someone without deep technical skills can navigate comfortably. My expertise will be reflected in clean code with named modules and comments, enabling hassle-free maintenance in-house as needed. By working together, we can build a reliable solution that streamlines your marketing decision-making process. Let's discuss your specific needs!
$20 USD em 1 dia
4,9
4,9

Hello, I can build your VBA-powered Excel Decision Support System with Solver integration, automated calculations, and dynamic dashboards for marketing budget optimization. I have strong experience in Excel automation, Solver models, and interactive reporting tools. The workbook will include flexible input sheets, fully automated macros for refresh and analysis, and clear dashboards showing budget allocation, ROI, and performance insights. Code will be clean, well-structured, and documented for easy maintenance. I will also provide a step-by-step guide or video for usage. Please share the base file so I can review and start. Thank you, Anuradha Mane
$20 USD em 7 dias
5,0
5,0

Dedicated Freelancer Ready to Elevate Your Project for Excel VBA Marketing Budget Tool. I have a solid background in Excel Macros, Data Processing, Data Analysis, Visual Basic for Apps, Data Management, Excel, Data Visualization, Visual Basic, Excel VBA and Office 365, I bring valuable expertise to your project. I have successfully completed many projects with 100% client satisfaction. Clear and timely communication is my priority. I believe in keeping you informed throughout the project lifecycle. I am available for a discussion at your earliest convenience. Please feel free to contact me to further discuss your project details. Thank you for considering my bid. I am excited about the opportunity to contribute to the success of your project. Please visit my portfolio to check my previous work samples, here - https://www.freelancer.com/u/GraphicsHub2k24?page=portfolio&w=f&ngsw-bypass= Best regards, Muhammad Asim Khan
$10 USD em 1 dia
3,9
3,9

Hello , I've just reviewed your project description regarding the Excel VBA Marketing Budget Tool and I'm confident in my ability to meet your expectations. With over 7 years of experience as a Senior Graphic Designer, I possess a strong skill set in Excel VBA, Data Analysis, Visual Basic for Apps, Excel, Excel Macros, Data Visualization, Office 365, Data Processing, Data Management and Visual Basic I kindly request you to take a moment from your busy schedule to explore our portfolio, where you can see the quality of my work and read feedback from previous clients: [Portfolio Links] https://www.freelancer.com/u/afshan2176 Could you please specify the final file formats you'll require? Feel free to award me the project so that we can discuss it further. Looking forward to connecting with you. Best regards, Afshan Z.
$10 USD em 1 dia
3,5
3,5

Hope you are doing well! Lets satrt Experience includes building VBA-powered Excel workbooks for decision support, integrating Solver, macros, and dynamic dashboards for automated analysis. Previous projects involved automating data refresh, pivot table creation, and chart updates while ensuring input flexibility so new monthly data could be added without breaking formulas or code. Advanced formulas, Power Query, and ActiveX controls were used to streamline calculations and reporting, with all features running smoothly in Office 365 without external add-ins. Challenges such as handling variable-length data and maintaining calculation integrity were solved with dynamic named ranges, error handling in VBA, and clear module documentation. Deliverables included macro-enabled workbooks, protected input/output sheets, and instructional guides (video or PDF) for in-house maintenance and customization. I know what do I build for you, can complete it to your full satisfaction within your timeline. I am ready for you and waiting here. Thank you.
$50 USD em 7 dias
3,2
3,2

Hi, I’d love to help build your Excel-based Decision Support System for marketing budget allocation. I have strong experience in Excel automation, VBA-driven reporting, dashboard design, and data analysis, and I can create a clean, practical .xlsm tool that is easy to use and maintain in-house. Based on your requirements, I can develop a workbook that accepts raw monthly spend and performance data, automates calculations, updates pivots/charts with one click, and uses Solver to optimise budget allocation for maximum profit. What I will deliver: A fully automated macro-enabled Excel workbook compatible with Office 365 Clearly separated input, processing, and dashboard/reporting sections Flexible data structure so new monthly data can be pasted in without breaking formulas or code Dynamic summary tables, ROI views, variance tracking, charts, and printable report pages Well-structured VBA modules with comments and clear naming for future maintenance A short step-by-step guide or PDF showing how to refresh data, add new months, and adjust reporting parameters I can also incorporate advanced formulas, Power Query, and user-friendly controls where they improve performance and usability—without relying on external add-ins. My focus will be to make the tool not only functional, but also reliable, professional, and easy for your team to operate day to day. I’d be glad to work on this.
$20 USD em 7 dias
2,1
2,1

Hello, I see that you need a Decision Support System in Excel that integrates Excel Solver and VBA macros to allocate your marketing budget efficiently. I am Mubashir Ahmed, a Full-Stack Developer, Engineer, and UI/UX Specialist with 6+ years of experience building high-performance tools for data analysis and visualization. I specialize in Excel VBA and data processing, creating automated solutions that enhance decision-making capabilities. To meet your requirements, I will deliver a macro-enabled workbook (.xlsm) that allows for seamless data input and processing, producing clear summaries and visualizations. The tool will include: - Fully automated workflows driven by VBA for calculations and updates. - Flexible input sheets to accommodate new monthly data without issues. - Dynamic output areas with summary tables, charts, and printable pages for easy budget allocation. - Clean, documented code to ensure maintainability for your in-house team. - A short video or PDF guide on refreshing data and customizing reports. - Step 1: Gather your raw spend and performance data. - Step 2: Implement VBA macros to automate calculations and data processing. - Step 3: Create dashboards and visualizations for quick insights. - Step 4: Deliver the final workbook and instructional materials. My Portfolio: https://www.freelancer.com/u/mubashir021 I look forward to helping you build this Excel VBA Marketing Budget Tool. Mubashir Ahmed
$39 USD em 7 dias
0,6
0,6

Hi, I will create a fully automated Decision Support System in Excel that efficiently allocates your marketing budget across channels. Leveraging VBA, Excel Solver, and advanced dashboard visualizations, I’ll ensure the workbook processes raw data seamlessly, yielding actionable insights to maximize profit. With extensive experience in developing similar systems, I understand the importance of a clean, user-friendly interface. I will design flexible input sheets that allow for easy monthly updates without disrupting any existing formulas. The output will feature dynamic summary tables, charts, and printable pages that clearly illustrate budget allocation and ROI. I will also prioritize thorough documentation and clean code structure to facilitate your in-house maintenance. Expect a macro-enabled workbook ready for Office 365, along with a straightforward guide on data refresh and customization. Are there specific marketing channels you want to emphasize, or any additional metrics you need in the dashboard? I’m ready to execute this project efficiently and effectively. Thank you.
$21,50 USD em 7 dias
0,0
0,0

I have done a similar project a week ago. I am sure you will give me more projects after this. I am interested to do this project too and ready to complete this within the timeline. Kindly check my profile to see all rating and reviews given by clients. Hoping to hear from you soon. Payment after completion.
$20 USD em 2 dias
0,0
0,0

Ankara, Turkey
Método de pagamento verificado
Membro desde dez. 12, 2021
$10-30 USD
$250-750 USD
$250-750 USD
£20-250 GBP
$30-250 USD
₹600-1500 INR
€250 EUR
₹37500-75000 INR
$10-30 CAD
$80-100 USD
$2-8 USD / hora
$250-750 USD
$15-25 USD / hora
₹1500-12500 INR
₹600-1500 INR
$30-250 USD
€250 EUR
$15-25 USD / hora
$250-750 USD
$30-250 USD