Looking for some guidance on this sheet.

[Paoblo]

Hi, wondering if there's anyone out here that can help, I'm trying but failing to get this sheet maybe I'm looking at the wrong thing, but have had no idea now what to do so hoping someone could help, thanks in advance.

So basically I'm looking for a sheet where I can enter numbers and it works out percentage, so done that, but I want that percentage to go into week 1 then when I enter it again it goes into week 2 then 3 etc, here's image attached thanks again.

Paul

 

[HighAndWilder]

I take it that, for example, the 800 and 400 would be overwritten each time that you are entering data for the next week.

The data should really be structured differently. It is something called 'Normalisation' and makes data management
and analysis much easier.

Add a new column between Shop and Total Hanging and call this Week which contains the week number.

You will just have four columns.

You will be keeping a history of all of the data from previous weeks and not overwriting data,

The presentation of this RAW data is then another task on another sheet.

One step at a time though.