sarahbravo
New Member
- Joined
- Jan 6, 2016
- Messages
- 1
Hi there, thanks in advance for reading this.
I have inherited a spreadsheet showing daily turnover that records the data and totals and displays it all in one sheet. It's a nightmare to try and make useful just because there are so many figures - 365 days with 8 departments, each comparing against the previous years daily total, providing increase/decrease information and weekly and monthly totals. It also is doing my head in trying to change it from 2015 vs 2014 to 2016 vs 2015. Should I try and keep three years data, should I show growth for all years? There is so much in there it is really unwieldy to use and not easy to read!!
Soooo, I thought I'd be clever and split the recording and display functions. If I youtube I can probably (with much swearing and consumption of chocolate) figure out a few nested countifs and a simple dashboard to display useful information. My actual question is the best way to record the raw information, ie like this
Date Week No Month Year Main Bar Beverage Sports Bar Beverage Bottleshop Beverage Restaurant Food Café Food Function Food
1-Jan-2016 all these autocalcd $2468 $872 $659 $5879 $645 $168
or like this:
Date Week No Month Year Department Total
1-Jan-2016 autocalc'd Main Bar Beverage $2468
1-Jan-2016 Sports Bar Beverage $872
1-Jan-2016 Bottleshop Beverage $659 etc etc
Any and all advice greatly appreciated. And if anyone knows a good book about simple database design, as well as the excel stuff to make it happen, I would appreciate a recommendation.
Hope everyone is having a happy 2016.
Sarah
I have inherited a spreadsheet showing daily turnover that records the data and totals and displays it all in one sheet. It's a nightmare to try and make useful just because there are so many figures - 365 days with 8 departments, each comparing against the previous years daily total, providing increase/decrease information and weekly and monthly totals. It also is doing my head in trying to change it from 2015 vs 2014 to 2016 vs 2015. Should I try and keep three years data, should I show growth for all years? There is so much in there it is really unwieldy to use and not easy to read!!
Soooo, I thought I'd be clever and split the recording and display functions. If I youtube I can probably (with much swearing and consumption of chocolate) figure out a few nested countifs and a simple dashboard to display useful information. My actual question is the best way to record the raw information, ie like this
Date Week No Month Year Main Bar Beverage Sports Bar Beverage Bottleshop Beverage Restaurant Food Café Food Function Food
1-Jan-2016 all these autocalcd $2468 $872 $659 $5879 $645 $168
or like this:
Date Week No Month Year Department Total
1-Jan-2016 autocalc'd Main Bar Beverage $2468
1-Jan-2016 Sports Bar Beverage $872
1-Jan-2016 Bottleshop Beverage $659 etc etc
Any and all advice greatly appreciated. And if anyone knows a good book about simple database design, as well as the excel stuff to make it happen, I would appreciate a recommendation.
Hope everyone is having a happy 2016.
Sarah
