Closed

Finalise "cascade" budget sheet

This project received 14 bids from talented freelancers with an average bid price of £154 GBP.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
14
Project Description

This assignment requires experience with Excel VBA. Please do NOT waste your bid if you cannot solve it.

I need someone to finish off the attached Excel 2010 "budget" spread sheet that has a different approach than usual.

Each month the User can select an "open ended" number of cost categories and enter limits on how much cash can be added to each category (either as a fixed sum for the month, a percentage of the total, or a limit each time the code "cycles" through the allocation),.

They then enter the funds to be placed, and the programme splits the money automatically between each category until everything has been placed. This can require several "cycles",

The output is then saved to the relevant Month on the database.

The key changes needed:
1. If a category is already at its' limit, allow the User to withdraw funds BEFORE the programme shares out the funds
2. Enable the User to recall the month and add more funds, which are then reassigned.

Any questions do not hesitate to message me.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online