Digital Ad Budget Spreadsheet Calculations and Design

Status: Closed
Prize: $50
Entries Received: 12
Winner: sachit89

Winner

Contest Brief

I have created a simple spreadsheet to calculate Digital Advertising Budgets for our clients based on categories of spend. The setup works fine if I am the one doing the numbers but I would like to make the spreadsheet available to clients so they can calculate their own results.

The original spreadsheet has been uploaded for your review. What I would like to do is allow the users to be able to enter data in the following formats:

1. I would like them to be able to enter their own Budget line item amount by category and have the %'s calculate after the total budget is added up from the individual entries.
2. I would like them to be able to enter a total budget and then have the spreadsheet calculate the Budget line item amount automatically based on the %'s I have put in the original spreadsheet.

The finished spreadsheet should allow the user to see a Visual Representation with a Pie Chart similar to what I have on the original spreadsheet.

I would like the spreadsheet to be very professional looking and Really EASY to use and for the formulas to be locked with a password being KainAutomotive.

Please use the attached logo to personalize the spreadsheet.

Thank you for considering assisting with this important project.

David

Recommended Skills

Excel

Winner

Post a Contest Like This

Employer Feedback

“I enjoyed working with sachit89. Great results. ”

carkain, United States.

Public Clarification Board

hansakaw
- 11 years ago
I would like to submit one, but you have already selected the winner.
- 11 years ago
Contest Holder
- 11 years ago
Thanks for all the great entries. I like the Orientation Screen provided in Entry #12 . I really like the on screen guidance by entry #9 . I just realized we will need to be able to Add Items and would need to either be able to work with you on an update or if you have the capacity for the users to add their own additional sources.
- 11 years ago
1. Rampage4Services
  - 11 years ago
  Current version has been created based on the original requirement. However, I am willing to work further to improve on this sheet and make changes to it as required.
  - 11 years ago
Contest Holder
- 11 years ago
I really like the on screen feedback in the document with entry #9 . I would like Entry #9 to be able to allow the user to adjust the Percentages and see what the adjustments will look like by Dollar amount. For example: If a user wanted to see what the cost would be if they wanted to allocate 50% of their budget to search.
- 11 years ago
1. Rampage4Services
  - 11 years ago
  The requested changes have been incorporated. I have added another option for the users to edit the percentages and look at the impact on allocation. I have also added some checks to ensure the numbers make sense.
  - 11 years ago
sachit89
- 11 years ago
And yes..absolutely willing to help out with updating/modifying the tool in the future.
- 11 years ago
sachit89
- 11 years ago
Hi. Have edited entry 12. Have added an option where the user can add/delete item -- essentially create a customized list. (If required). If not, then the default options will be there. I have uploaded the update as a new entry (Entry 13). (Please consider 12 itself for comments as it is sealed) Thanks.
- 11 years ago
ACMAuk
- 11 years ago
Dear CH,I am working on it, so please don't close the contest before the schedule.
- 11 years ago
momo2619
- 11 years ago
How about #6 . you can input everything you want there as needed without confustion?
- 11 years ago
Contest Holder
- 11 years ago
Entry #7 I like the buttons built on the screen but I don't understand where you enter the numbers.
- 11 years ago
momo2619
- 11 years ago
in #6
When you run the software, it loads this form as it looks in the image.
You can select between options (opt1 and opt2 as you wrote in the project description).
And the form loads the default % which can be edited as you requested
- 11 years ago
1. Contest Holder
  - 11 years ago
  Ok...Thanks.
  - 11 years ago
Contest Holder
- 11 years ago
momo2619. I am confused. Sorry, I don't understand clearly how to do it and I would worry that our clients would have trouble as well.
- 11 years ago
momo2619
- 11 years ago
I edited that and added #5
- 11 years ago
momo2619
- 11 years ago
After pressing run, you can edit it.
Or I can add that to the form if needed and you dislike to edit that into the sheet itself
- 11 years ago
momo2619
- 11 years ago
I hope my design can fit in your request as it can handle option1 and option2 more than any other design
- 11 years ago
Contest Holder
- 11 years ago
I like the idea of entry #3 but what if we want to adjust the % manually?
- 11 years ago
keithinniss
- 11 years ago
I am a Fellow of the Institute of Canadian Bankers, and served in banking for 32 years. During this time I served in the following areas:
Administrative officer over all banking operations,
Accountant,
Manager retail banking,
Chief financial officer,
Secretary to the Board of Directors,
Broker on the stock exchange,
Assistant in the audit department,
Assistant in the human resources and payroll department
I also acted as the Chief Executive Officer

Additionally, I am experienced in writing business and marketing plans, investment policies, sales campaigns, balanced scorecards, asset liability management policies, lease agreements, employment contracts, maintenance contracts, business continuity policies, operations manuals, job descriptions, etc.

I am trained in the use of Microsoft programs such as Excel, Word and PowerPoint.
- 11 years ago
Contest Holder
- 11 years ago
I also, prefer the split apart pie for more clarity and visual impact.
- 11 years ago
Contest Holder
- 11 years ago
Option 1 for data entry would be for the user to complete the Dollar Amounts. Option 2 for data entry would be for the user to complete the Total Budget Amount and then use the Default %'s to calculate the individual budget dollars and Option 3 for the user to Enter the %'s they would like to use as well as the Total Budget so they can control more factors.
- 11 years ago
Contest Holder
- 11 years ago
Entry #2 is in the direction of the more simple approach and brings up a 3rd Option I'd like to consider.
- 11 years ago
Contest Holder
- 11 years ago
Thanks for your entry. If I was a Novice user I might have a difficult time understanding what to do. A Legend that was more clear would be helpful. Also, on the branding, I would like our logo to blend more naturally.
- 11 years ago