Storing and and later analyzing data

[magrim]

My knowledge of excel is rather limited as you can read from the request below, however I would appreciate any assistance or advise on the matter.
I work in admissions and we are inputting weekly group bookings for one year in advance. We are taking bookings for every week in July and August.
Bookings keep changing, we are deleting and adding as we go along. We are 3 working on the same document. However, we would like to keep all the records to be able to analyze them without storing every single version when we amend the document. What would be the best way to do so.
We basically have vertically week, 1, week 2,.... until week 8 and horizontally names of groups and we write number of people in respective weeks
Thanks in advance for any advice , Magrim

 

[oldbrewer]

	week1	week2	week3	week4	week5	week6	week7	week8
location1	3	5	4		3	3	4	4
location2		4	4	4		3	4	4
location3	6	8	6		8	8	8	8
		is it like above if so have a log under it
location	week	changed from	changed to	who by	date			whoever makes a change
2	3	2	4	fred	01/08/2017			saves the workbook
3	7	6	8	bill	03/08/2017			so you keep a record of the amendments

<colgroup><col span="5"><col><col span="7"></colgroup><tbody>
</tbody>

 

[magrim]

	week1	week2	week3	week4	week5	week6	week7	week8
location1	3	5	4		3	3	4	4
location2		4	4	4		3	4	4
location3	6	8	6		8	8	8	8
		is it like above if so have a log under it
location	week	changed from	changed to	who by	date			whoever makes a change
2	3	2	4	fred	01/08/2017			saves the workbook
3	7	6	8	bill	03/08/2017			so you keep a record of the amendments

<tbody>
</tbody>

Thanks. It is actually the other way around, it is something like the table below:

	group 1	group 2	group 3	group 4
week 1		7		11
week 2	22	8		11
week 3	11	8
week 4	21	9	34
week 5	9		12
week 6
week 7

<tbody>
</tbody>

However your suggestion would still work.Thanks,M