Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-09-2021, 06:40 AM
danluk12 danluk12 is offline I can resolve this  summary of sales forecast. Please help! Windows 10 I can resolve this  summary of sales forecast. Please help! Office 2016
Novice
I can resolve this  summary of sales forecast. Please help!
 
Join Date: May 2021
Posts: 1
danluk12 is on a distinguished road
Default 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
Attached Files
File Type: xlsx Rev Forecast 0.1 (1) (2).xlsx (58.7 KB, 10 views)
Reply With Quote
  #2  
Old 05-09-2021, 08:40 AM
jeffreybrown jeffreybrown is offline I can resolve this  summary of sales forecast. Please help! Windows 10 I can resolve this  summary of sales forecast. Please help! Office 2016
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Not sure all the facts are there, but this could be one way.
Attached Files
File Type: xlsx Rev Forecast 0.1 (1) (2).xlsx (70.8 KB, 9 views)
Reply With Quote
  #3  
Old 05-09-2021, 11:25 PM
ArviLaanemets ArviLaanemets is offline I can resolve this  summary of sales forecast. Please help! Windows 8 I can resolve this  summary of sales forecast. Please help! Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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.
Attached Files
File Type: xlsx AccountingExample.xlsx (22.6 KB, 7 views)
Reply With Quote
  #4  
Old 05-10-2021, 03:46 PM
macropod's Avatar
macropod macropod is online now I can resolve this  summary of sales forecast. Please help! Windows 10 I can resolve this  summary of sales forecast. Please help! Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #5  
Old 05-12-2021, 12:01 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline I can resolve this  summary of sales forecast. Please help! Windows 7 64bit I can resolve this  summary of sales forecast. Please help! Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Also cross posted at I can resolve this summary of sales forecast. Please help!
Reply With Quote
Reply

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
I can resolve this  summary of sales forecast. Please help! 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft