#1
|
|||
|
|||
I can resolve this summary of sales forecast. Please help!
Hi,
I have a problem solving this task. Please help! Nothing is clear to me. If anyone can do this task and explain to me what he did. Create a summary of sales forecast for years 1-5, using the data below |
#2
|
|||
|
|||
Not sure all the facts are there, but this could be one way.
|
#3
|
|||
|
|||
I'd scrap your current workbook, and create something like in added example (I designed a minimum of it, simply to give you some ideas). The idea is all data entry (except various registers) are on single worksheet, and what you have currently for data entry (a sheet for every year) are replaced with a single report sheet (+ another report sheet you are asking help for).
For RepSummary report, you set data validation lists to select start and end years, and a summary table for any number of years is displayed. All info which is calculated based on another data (like Conversion, Income, Payment Processing Expenses, etc.), are calculated only in reports. The design is easiest, when on data entry sheet real values are entered for every month for every account. When you want to keep the practice, where an amount is entered for some month, and afterwards next entry is calculated based on previous month value (as is in your example), the design will get more complicated (e.g. you need an additional registry for percentages per account an year, have to enter rows with empty amounts for calculated months, and have additional amount column, where entered amount is read in in case such exists, or the amount is calculated based on previous data. This kind of design ensures, you design the app once, ant you can practically forget it. I have some apps made nearly 20 years ago, which are in use yet, and there was no need for me to edit them. |
#4
|
||||
|
||||
Cross-posted at: I can't resolve this summary of sales forecast. Please help! | Chandoo.org Excel Forums - Become Awesome in Excel
For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
||||
|
||||
Also cross posted at I can resolve this summary of sales forecast. Please help!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sort transaction file into Sales Summary | Rogiv | Excel | 3 | 05-10-2019 12:46 AM |
How to calculate summary progress date time on summary tasks | Logotip | Project | 0 | 05-16-2017 01:18 AM |
Forecast Sheet | Bowzo | Excel | 1 | 01-26-2017 08:33 AM |
Help please - billing and cost forecast model | dee38 | Excel | 0 | 10-26-2016 09:43 AM |
Rollup Summary Tasks to Project Summary Task | shep555 | Project | 1 | 05-24-2014 12:28 PM |