prepare excel sheet
Prepare a excel sheet I have list of all the ammenties with the price used in the hotel room we need to prepare excel sheet in such a way that it allow us to enter the total consumption of ammenties every day and it show automatically calculate the total price cosumed .it should basically track waht ammenties and how many been used and after entering the data it should refet in a chart form.
and end of the day and year i want to compare every ammenities used in referennce to the number and price and compare in daily + month basis.
i have attached the price and product list