Hello,
I am using Excel to manage the sales data and inventory for a restaurant. I know that a database would be a more appropriate tool, but the owner is cheep and that won't happen. The problem I am running into is that what is easy for data entry is not ideal for creating pivot tables. Currently I have most data in cross tabular format.
EG:
date gross sales net sales #of sandwiches gift cards sold
1/1/1 $2104.04 $1975.33 122 5
What makes pivot tables most flexible is a single row per variable
EG:
Date Metric value
1/1/1 gross sales $2104.04
1/1/1 net sales $1975.33
1/1/1 # of sandwiches 122
1/1/1 gift cards sold 5
obviously the latter is a pain for data entry and the former much simpler.
Does anyone have any suggestions to make this process simpler? Each day I will need to collect about 50 data points. I also need a flexible solutions as recipes, promotions, and ingredients change frequently.
Thanks.
I am using Excel to manage the sales data and inventory for a restaurant. I know that a database would be a more appropriate tool, but the owner is cheep and that won't happen. The problem I am running into is that what is easy for data entry is not ideal for creating pivot tables. Currently I have most data in cross tabular format.
EG:
date gross sales net sales #of sandwiches gift cards sold
1/1/1 $2104.04 $1975.33 122 5
What makes pivot tables most flexible is a single row per variable
EG:
Date Metric value
1/1/1 gross sales $2104.04
1/1/1 net sales $1975.33
1/1/1 # of sandwiches 122
1/1/1 gift cards sold 5
obviously the latter is a pain for data entry and the former much simpler.
Does anyone have any suggestions to make this process simpler? Each day I will need to collect about 50 data points. I also need a flexible solutions as recipes, promotions, and ingredients change frequently.
Thanks.
